Date Rounding Off

[imrasyed]

Hi Experts,

I have a Date  as 9999-12-31 23:59:59.999999 from Source and when i load it in Qliksense it is rounding it off to 

10000-1-1 00:00:00.

Is there anyway I can stop rounding it off and display the date as is from Source?

[arulsettu]

Maybe like this

date(floor('9999-12-31 23:59:59.999999'))

which give 31/12/9999

[JordyWegman]

Hi,

Try this:

Date(floor('9999-12-31 23:59:59.999999'),'YYYY-MM-DD')

This way you will have the same format, but without the timestamp.

Jordy

Climber 

[imrasyed]

Hi Thanks for the Answer but its a value in a column.

I got a solution by using the function to_timestamp(Date,'format')  on Data Source and getting it to Qlik.