topic Two Different Date Formatts In A Field in QlikView

Two Different Date Formatts In A Field

Thu, 27 Jun 2013 15:02:05 GMT

I have a field that contains two different date type. They are as follows:

MM/DD/YYYY HH:MM:SS

M/D/YYYY HH:MM:SS

I want to remove the HH:MM:SS. Typically, I would use LEFT(MyDate, 10) for the MM/DD/YYYY HH:MM:SS. But since I have the two formats this does not work because for the dates in M/D/YYYY HH:MM:SS the LEFT(MyDate, 10) will pull in the first "H" into my new date. How do I convert these two formats into on date format of MM/DD/YYYY?

Thanks in advance for your help

Brian

Re: Two Different Date Formatts In A Field

onetwothree123 — Thu, 27 Jun 2013 15:10:23 GMT

Prox,

Use Date([FieldName],'MM/DD/YYYY')

Re: Two Different Date Formatts In A Field

Gysbert_Wassenaar — Thu, 27 Jun 2013 15:27:47 GMT

See this blog post: Get the Dates Right

Re: Two Different Date Formatts In A Field

onetwothree123 — Thu, 27 Jun 2013 15:33:44 GMT

Gysbert,

Thanks for sharing HC's date post.

Re: Two Different Date Formatts In A Field

nizamsha — Thu, 27 Jun 2013 15:46:05 GMT

date(Myfield,'DD-MMMM-YYYY')