Date issue

[Anonymous]

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

[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]

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]