topic Re: Issue with Date format in QlikView

Issue with Date format

varunreddy — Thu, 02 Feb 2017 20:45:58 GMT

Hi All,

I am trying to convert the Date from 'DD/MM/YYYY' to 'DD MMM YYYY'.

My date here is 9/1/2017 (DD/MM/YYYY), when I try to convert to 'DD MMM YYYY', I get '01 Sep 2017' instead of '09 Jan 2017'. If I have 31/1/2-017 I don't see any date when I use 'Monthname' function.

Did anyone come across this kind of scenario?

Thanks in advance!

Cheers,

Varun

Re: Issue with Date format

krishnacbe — Thu, 02 Feb 2017 20:59:18 GMT

Hi,

Change the Default Date format as below

SET DateFormat='D/M/YYYY';

LET vDate = Date('9/1/2017','DD MMM YYYY');

Re: Issue with Date format

el_aprendiz111 — Thu, 02 Feb 2017 21:03:14 GMT

Hi:

1 Example:

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

Re: Issue with Date format

varunreddy — Thu, 02 Feb 2017 21:15:28 GMT

Hi fer,

Thanks for the quick response. It worked. What was the issue?

Cheers,

Re: Issue with Date format

varunreddy — Thu, 02 Feb 2017 21:16:24 GMT

Hi Krishna Priya,

Thanks for your quick response. It is still showing the same issue.

Cheers,

Re: Issue with Date format

Chanty4u — Fri, 03 Feb 2017 06:48:44 GMT

Hi,

Try below

=Date(Date#(Datefield, D/MM/YYYY'),'DD/MMM/YYYY') as newdate

Re: Issue with Date format

Fri, 03 Feb 2017 09:03:57 GMT

Hi Varun,

Whenever you need to change date from one format to another than better use Date# function.

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

Regards

Deepak