Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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
Contributor II
Contributor II

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

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';


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