Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
while converting the timestamp to num its giving incorrect number as shown below
Actual values for
26/04 - 44312
29/04 - 44315
kindly help me ..
If you don't need the fraction value for the timestamp, try like:
Num(Floor(createdbydate)) as numcreate
hi sir,
i have written same logic .. but still i am getting in correct num .
same as the screenshot given above ..
when i write the same logic in the table chart as dimension i am getting correct numbers ..
second column as a calculated dimension
3rd columns .. same logic in script level
Are you using any formatting function in script?
Date(Floor(createdbydate), 'MM/DD/YYYY') AS [CREATED_DT]
Actually my requirement is to get days between two days . But unfortunately, i was not able get the days incorrect due to create date into conversion in scripting level .
to get difference between two dates , i have written below logic
Ceil(Interval(Date(lastmodifieddate, 'DD/MM/YYYY hh:mm') - Date(createdbydate, 'DD/MM/YYYY hh:mm'), 'DD' ))
What if you try like:
Interval(lastmodifieddate -createdbydate, 'D')
your screenshot looks like there is each combination of field values generated in this table suggesting that there is an issue in your data model rather than a simple timestamp to integer conversion issue.
Can you check again how your numcreate field is generated?
Maybe it is in a different (island) table, the key fields are not properly generated or the numcreate field is not properly joined to the table that contains createdbydate ?
hope this helps
regards
Marco