topic Re: Help me with converting date format. in QlikView

Help me with converting date format.

Wed, 08 Jan 2014 03:16:00 GMT

I have a date field called Monthrecorded in myy format.How can I covert this into mmddyyy format.

Thanks in advance.

Siva_Sankar — Wed, 08 Jan 2014 03:25:50 GMT

use

=(monthfieldname,'MM-DD-YYYY')

Regards.

Siva

Wed, 08 Jan 2014 03:35:43 GMT

I am getting the syntax error.can you tell me why?

Thanks.

Anonymous — Wed, 08 Jan 2014 03:38:18 GMT

Use the function

date(Monthrecorded ,'MMDDYYY')

jagan — Wed, 08 Jan 2014 03:38:56 GMT

Hi,

Try like this

=date(Date#('114', 'MYY'), 'MMDDYYYY' )

Regards,

Jagan.

Wed, 08 Jan 2014 06:41:29 GMT

Hello,

You can use below expression:

=Date(Date#(Monthrecorded,'MYY'),'MMDDYYYY')

Thanks,

Angad

dmohanty — Wed, 08 Jan 2014 06:45:11 GMT

Try this:

=Date(Date#(Monthrecorded,'MYY'),'MMDDYYYY')

Wed, 08 Jan 2014 07:22:56 GMT

Hi Aptha,

Please send me the sample data will try to give solution. May be your field is having the string data. that is what its showing the syntax error.