Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Qliksense7
Contributor II
Contributor II

Datepicker issues

My dataset has the Date format as 'M/D/YYYY hh:mm:ss TT'. I need to obtain a Date picker with the date field in the format mentioned
I changed the script in the data load editor to this format mentioned loaded the data and also created a new dimension with  date format mentioned above. I'm still not able to get any parameters in the date field to move forward 
I'm still facing the error "Invalid Dimension". Is there any way to obtain a date range with the mentioned format?

Thanks for the help 

2 Replies
QlikkitySplits
Contributor II
Contributor II

i would also  like to know how to fix this same problem.

kbush
Contributor II
Contributor II

I had a similar issue. My data set format was 'M/D/YYYY h:mm TT'. 

In the data load, I changed the TimestampFormat to match the data and used Timestamp on my field. 

//SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET TimestampFormat='M/D/YYYY h:mm TT';

Timestamp([DateField])

In the DatePicker, use Language and Labels > Format to display as needed.