Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
Hi,
Change your date format like below
=Date((CLM_CR_DT),'DD/MM/YYYY hh:mm:ss')
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
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...
Hi try like this
Date(Date#(DateField, 'YYYYMMDD'), 'M/D/YY')
Get the Dates Right
Hope this will help you
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.
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.
Hi
Have you tried this
=Date((your_Date_Fild),'DD/MM/YYYY hh:mm:ss')
hi... I gt the date as I required.
Can yu please explain wat we are doing here exactly.??
Regards,
Reena
Nice Work Micheal
