Discussion Board for collaboration related to QlikView App Development.
I am using the following line code to pick a date using peek function.
And I want to use the variable vDate in LOAD statement. After execution, the table which loaded has decimal values instead of dates.
I want to get the exact dates. Its because Peek function returns a string. I am not able to figure out a way to get the date value when I use in LOAD statement.
Thanks in advance.
Go to Solution.
Try using single quotation marks around the variable:
'$(vMDMTargetDate)' as vDate
The number you get is 6 divided by 17 divided by 2011 ( 6/17/2011 ), QlikView expands the variable and then tried to evaluate the expanded.
Hope this helps,
i think DATE function would help you. Can you upload sample application?
The variable holds the numerical representation of the value retrieved from the DateField, so I think this is ok.
When you recall the variable value, you could use Date() function then to format the date, like
Date($(vDate)) as PeekedDate,
to format it with standard date format (or specify the format code string as second parameter in Date() function).
Nope date function didnt work.
Attached please find the sample. I would appreciate any help.
it seems that your source file has timestamp for date field as in [Date of Delivery] and it is not being taken in right format for date. can sample source files(csv) be uploaded?
Thanks guys single quotation mark around the variable worked!
thanks again guys.