Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how handle dates problem

I have a variable date which is initially 20151231

dates.png

I always got this date initial as the following picture

dates2.png

I feel confused , is there a way to resolve it ?

1 Solution

Accepted Solutions
marcus_sommer

Your variable-value won't be recognized as date. If you creates the variable use a format-function, something like this:

let vFromDate = date(date#(20151231, 'YYYYMMDD'));

- Marcus

View solution in original post

2 Replies
marcus_sommer

Your variable-value won't be recognized as date. If you creates the variable use a format-function, something like this:

let vFromDate = date(date#(20151231, 'YYYYMMDD'));

- Marcus

saurabh5
Creator II
Creator II

hi ,

for all date variables use date functions to convert to appropriate format, so that you can use thee variable in calender object and also it will be easy to  do any calculations to calcute time period.

Regards

S