timestamp to num conversion

[harsha087]

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 ..

[tresesco]

If you don't need the fraction value for the timestamp, try like:

Num(Floor(createdbydate)) as numcreate

[harsha087]

hi sir,

i have written same logic .. but still i am getting in correct num . 

same as the screenshot given above .. 

[harsha087]

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

[tresesco]

Are you using any formatting function in script?

[harsha087]

Date(Floor(createdbydate), 'MM/DD/YYYY') AS [CREATED_DT]

[harsha087]

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' ))

[tresesco · Accepted solution]

What if you try like:

Interval(lastmodifieddate -createdbydate, 'D')

[MarcoWedel]

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