This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
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;
View solution in original post
if you want same format in 2nd field you can use below exp.
refer below for for information
I don't need the same format, but if you look at the second column, from second row date number looks odd
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/DateAnd...
Nice. I've never used those functions (Day*) but just might start updating some reports with this. Thanks Marco!