topic Re: date formate in QlikView

date formate

balasundaram — Tue, 16 Sep 2014 07:41:34 GMT

1-Jul-2014 to 7/1/2014

how to convert?

Anonymous — Tue, 16 Sep 2014 07:47:49 GMT

Try this

Date(Your_Date,'MM/DD/YYYY')

MayilVahanan — Tue, 16 Sep 2014 07:52:03 GMT

Try like this

Date(Date#('1-Jul-2014','D-MMM-YYYY'),'M/D/YYYY') as DateField

Date(DateField,'M/D/YYYY') as DateField

Tue, 16 Sep 2014 07:56:13 GMT

Mayil vahanan ramasamy is correct

amit_saini — Tue, 16 Sep 2014 07:56:22 GMT

Try this:

Date(Date_Field,'M/D/YYYY')

Thanks,

MK_QSL — Tue, 16 Sep 2014 07:59:18 GMT

=Date(Date#('1-Jul-2014','D-MMM-YYYY'),'M/D/YYYY')

=Date(Date#('YourDateField','D-MMM-YYYY'),'M/D/YYYY')

jagan — Tue, 16 Sep 2014 08:03:56 GMT

Hi,

Try like this

Date(Date#('1-Jul-2014', 'D-MMM-YYYY'), 'M/D/YYYY')

Hope this helps you.

Regards,

Jagan.