Date ?

[#1]

Hi...

I have date and time combined field in my SQL db. they have used Longtodate function extract the date in DB. how to get the exact date in QLikview??

Eg : My Date filed shows the value "1419310077901".

[krishna20]

Hi,

Change your date format like below

=Date((CLM_CR_DT),'DD/MM/YYYY hh:mm:ss')

[satishkurra]

For any kind of date problems it is recommended to use the below

Date(Date#(Date,'YYYYMMDD')) as Date,

Date# converts text to number and Date converts number to text.

Thanks

Satish

[Anonymous]

Can you explain what exactly date and time is represented by value '1419310077901'?

Most likely you need the timestamp#() function, but I can't guess the format...

[Anonymous]

Hi try like this

Date(Date#(DateField, 'YYYYMMDD'), 'M/D/YY')

Get the Dates Right

Hope this will help you

[#6]

even I am nt able to guess the format.when I extract the table from DB.it gives me the date in this format. and they are using LONGTODATE function inorder to extract the date.

[Anonymous]

From what I read about longtodate - it is the number of milliseconds from the "beginning of time" (1970).  If this is the case, this should work:

=timestamp(addyears(timestamp(YourDateField/86400000),70))

Where 86400000 is the number of milliseconds in one day.

[krishna20]

Hi

Have you tried this

=Date((your_Date_Fild),'DD/MM/YYYY hh:mm:ss')

[#9]

hi... I gt the date as I required.

Can yu please explain wat we are doing here exactly.??

Regards,

Reena

[Anonymous]

Nice Work Micheal