topic Re: Date issue in QlikView

Date issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date issue

sunny_talwar — Mon, 21 Mar 2016 10:27:40 GMT

May be this:

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

Re: Date issue

Anonymous — Mon, 21 Mar 2016 10:46:25 GMT

Thanks sunny for your reply. But no use

Re: Date issue

arulsettu — Mon, 21 Mar 2016 10:51:28 GMT

post some sample file

Re: Date issue

sunny_talwar — Mon, 21 Mar 2016 10:54:05 GMT

Can you share the current format of site_visit_start_datetime_key field?

Re: Date issue

Anonymous — Mon, 21 Mar 2016 10:59:55 GMT

Pls find the screen shot.

Re: Date issue

sunny_talwar — Mon, 21 Mar 2016 11:01:40 GMT

This looks like a datefield and not timestamp. May be this:

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

Re: Date issue

Kushal_Chawda — Mon, 21 Mar 2016 11:06:42 GMT

try this

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

Re: Date issue

Anonymous — Mon, 21 Mar 2016 11:07:06 GMT

Thanks Sunny. It is working fine.

Being new to this Qlikview. Can you tell me, Is there any way to find out whether date field is date or not.

Re: Date issue

bohravanraj — Mon, 21 Mar 2016 11:08:53 GMT

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

Re: Date issue

Kushal_Chawda — Mon, 21 Mar 2016 11:09:27 GMT

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.

Re: Date issue

sunny_talwar — Mon, 21 Mar 2016 11:09:41 GMT

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.

Re: Date issue

raghvendrasingh — Mon, 21 Mar 2016 11:10:35 GMT

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

Re: Date issue

Anonymous — Mon, 21 Mar 2016 11:23:40 GMT