Export to Excel issue

[Yosef]

Hello,
I am new to QS and I have a problem when I export a table to Excel,
In QS you can see a calculation of days of open Jira but when I export it to Excel it shows some random date,

Kind regards,
Yosef.

[Chanty4u]

is the logic implemented in Script for that measure or in front end?

can you paste the logic used ?

[Yosef]

the expression in Days open column:
Interval(now()-CREATED)

and in the data load editor:

DateLink:

Load

ISSUE_ID,

    Floor(CREATED) AS DateID,

    'Created' AS DateType

Resident ISSUE;

Load

ISSUE_ID,

    Floor(UPDATED) AS DateID,

    'Updated' AS DateType

Resident ISSUE;

Load

ISSUE_ID,

    Floor(RESOLUTIONDATE) AS DateID,

    'Resolution' AS DateType

Resident ISSUE;

errormode=0;

MinMaxDates:

Load

Min(DateID) As MinDate,

Max(DateID) As MaxDate

Resident DateLink;

Let vStartDate=Peek('MinDate');

Let vEndDate=Peek('MaxDate');

Let vDiff=vEndDate-vStartDate+1;

Drop Table MinMaxDates;

DateCalendar:

Load *,

Date(MonthStart(DateID), 'YYYY-MM') As YearMonth,

Year & '-' & Quarter As YearQuarter,

WeekYear & '-' & Num(Week, '00') As YearWeek;

Load

DateID,

Year(DateID) As Year,

Month(DateID) As Month,

Date(DateID) As Date,

Day(DateID) As Day,

    WeekDay(DateID) AS WeekDay,

    //floor(CREATED)=floor(Today())

    IF(floor(Today())= DateID,'Today','NotToday') AS Today,

     IF(Week(Today())= Week(DateID),'CurrentWeek', IF(Week(Today())-1= Week(DateID),'LastWeek','Two Weeks Ago +')) AS WeekSelect,

Week(DateID) As Week,

'Q' & Ceil(Month(DateID)/3) As Quarter,

WeekYear(DateID) As WeekYear,

-Year2Date(DateID) As YTD_Flag,

-Year2Date(DateID, -1) As LYTD_Flag;

Load 

RecNo()-1+$(vStartDate) As DateID

AutoGenerate($(vDiff))Where Exists(DateID,RecNo()-1+$(vStartDate));

errormode=1;

[kfoudhaily]

Hello,

force format in script and in mesure

num(Interval(now()-CREATED,'dd'))

[Yosef · Accepted solution]

Hi,

I forced the format and it didn't help, but I changed the number format to a number and it works,

Thank you!

[nirefraty123]

You can easily achieve that and much more with this extension:

https://logiexport.logsys.co.il/