topic Re: Date Fields in QlikView

Date Fields

oanalung — Thu, 05 May 2022 11:38:42 GMT

Hi,I am loading some date fields, using date(MyDateField) when I am doing the load, however if I convert the date to num - num(MyDateField) I can two different formats and values look odd.

From the image below first column is the MyDateField and second is num(MyDateField), but if you look at the second column, from second row date number looks odd

Any idea why?

Re: Date Fields

durgesh22 — Thu, 05 May 2022 11:06:47 GMT

@oanalung

if you want same format in 2nd field you can use below exp.

Date(num(datefield),'DD/MM/YYYY')

refer below for for information

help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Date.htm

Re: Date Fields

oanalung — Thu, 05 May 2022 11:38:27 GMT

I don't need the same format, but if you look at the second column, from second row date number looks odd

Re: Date Fields

Anonymous — Thu, 05 May 2022 15:25:39 GMT

Dates are numeric. The second column has values to the right of the decimal indicating it has a timestamp associated to it. If you don't want that and just the date use Floor;

Date(Floor(YourDateField),'DD/MM/YYYY')

HTH,

John

Re: Date Fields

MarcoWedel — Thu, 05 May 2022 19:31:22 GMT

To purge the fractional time part of your timestamps and at the same time format as date, you can use the DayName() function as well:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/dayname.htm

Re: Date Fields

Anonymous — Thu, 05 May 2022 20:41:39 GMT

Nice. I've never used those functions (Day*) but just might start updating some reports with this. Thanks Marco!