topic Re: Dates in QlikView

Dates

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

I have the following Table File:

How can i convert the "Patent_Expire_Date_Text" field into a date?

Regards.

Chris

vishsaggi — Thu, 15 Feb 2018 03:29:34 GMT

Try this?

LOAD *, Date(Date#("Patent_Expire_Date_Text", 'MMM DD, YYYY'), 'MM/DD/YYYY') AS PatentExpireDate_Formatted

FROM youtablename;

Anonymous — Thu, 15 Feb 2018 03:47:08 GMT

Thank you i will try it and advise

Regards

Chris

shiveshsingh — Thu, 15 Feb 2018 04:51:16 GMT

date(date#(Patent_Expire_Date_Text,'mmm dd,yyyy'),'DD/MM/YYYY') as Patent_Expire_Date

Use this while loading.

tamilarasu — Thu, 15 Feb 2018 05:46:48 GMT

FYI, you should use capital M for month i.e MMM. I believe small 'm' denotes Minutes and capital 'M' denotes Month.

shiveshsingh — Thu, 15 Feb 2018 06:09:52 GMT

Yeah, you are absolutely correct. Thanks for poiniting the mistake

date(date#(Patent_Expire_Date_Text,'MMM DD,YYYY'),'DD/MM/YYYY') as Patent_Expire_Date

tamilarasu — Thu, 15 Feb 2018 06:14:27 GMT

No problem