Dates

[Anonymous]

I have the following Table File:

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

Regards.

Chris

[vishsaggi]

Try this?

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

FROM youtablename;

[Anonymous]

Thank you i will try it and advise

Regards

Chris

[shiveshsingh]

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

Use this while loading.

[tamilarasu]

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

[shiveshsingh · Accepted solution]

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]

No problem