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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date issue

Hi,

I have an issue with date.

I am trying to convert date value YYYYMMDD to DD/MM/YYYY. But it is not giving any result with the below expressions.

=Date(Floor(TimeStamp#(site_visit_start_datetime_key, 'DD/MM/YYYY hh:mm:ss')))

=Date(Floor(TimeStamp#(site_visit_start_datetime_key, 'DD/MM/YYYY')))

Any suggestions on this

Regards,

Kumar

13 Replies
Kushal_Chawda

when you take the Date Field in listbox, if date is right aligned then it means that it is proper date format, in your case it is left aligned so it is not in proper date format.

sunny_talwar

I usually bring the field into QlikView without any manipulation and then create a straight table with DateField as dimension and Num(DateField) as expression. If you see all nulls in the DateField, then it means that QlikView did not read your dates as Number, they are being read as text.

raghvendrasingh
Creator II
Creator II

Hi Kumar Avisakula,

Please try this one :-

Date(Date#(site_visit_start_datetime_key,'YYYYMMDD'),'DD/MM/YYYY')

Hope This will help.

Thanks & Regards,

Raghvendra Singh

Anonymous
Not applicable
Author