topic Re: DATE function, need help in QlikView

DATE function, need help

Thu, 25 Oct 2012 06:42:22 GMT

Hi All,

i am trying to convert date format from DD-MMM-YY(15-Oct-12) into DD/MM/YYYY(15/10/2012)

i tried no. of ways as below:

DATE(DATE#(FIELD),'DD/MM/YYYY')

DATE(DATE#(FIELD,'DD MMM YYYY'),'DD/MM/YYYY')

But, i am getting empty fields only.

any help much appreciated.

Re: DATE function, need help

swuehl — Thu, 25 Oct 2012 06:45:19 GMT

Maybe

DATE(DATE#(FIELD,'DD-MMM-YYYY'),'DD/MM/YYYY')

DATE(DATE#(left(FIELD,11),'DD-MMM-YYYY'),'DD/MM/YYYY')

Re: DATE function, need help

Thu, 25 Oct 2012 06:49:54 GMT

ha, i think, i got to work on year as i am getting only last 2 digits!

Re: DATE function, need help

Thu, 25 Oct 2012 06:52:42 GMT

Hi Swuehl,

yes, your first suggestion did the trick.

thanks a lot for ur quick reply & help.

Re: DATE function, need help

swuehl — Thu, 25 Oct 2012 06:53:52 GMT

Ah, sorry, your input format is DD-MMM-YY only two YY digits, right?

DATE(DATE#(FIELD,'DD-MMM-YY'),'DD/MM/YYYY')

DATE(DATE#(left(FIELD,11),'DD-MMM-YY'),'DD/MM/YYYY')

Your format code in the date#() function should exactely match your format of your strings.

Check your input values in table view or a list box. Check also, that they are not already interpreted as dates (maybe your standard date format is 'DD-MMM-YY'?).