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.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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.