topic Re: how to get date format in QlikView

how to get date format

sannidhikumar — Fri, 09 Jun 2017 08:26:43 GMT

Hi All ,

how to get date format .

and i am using this date(date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY') AS MonthYear1 not getting correct

output.

to Ex: Jan-2017

thanks ,

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 08:44:18 GMT

The expression seems ok, please ensure the format of [Due Date] is DD-MMM-YYYY

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 08:45:43 GMT

=Date(Date#('09-Jun-2017','DD-MMM-YYYY'),'MMM-YYYY') is working fine for me. Please see attached.

Re: how to get date format

sujeetsingh — Fri, 09 Jun 2017 08:47:07 GMT

Expression seems okay. just check the data types.

Re: how to get date format

Peter_Cammaert — Fri, 09 Jun 2017 08:56:26 GMT

Care to enlighten us on what exactly you mean by "...not getting correct output...". What is it you get right now, and what do you need?

Re: how to get date format

qlikcheepirishe — Fri, 09 Jun 2017 08:58:09 GMT

Hiii pradeep,

please find attachment below.

date() gives date for the field & date#() specifies the format which should be set

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:13:16 GMT

hi All ,

thanks for reply i need out put as like this .

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:14:22 GMT

due date is field name i am using .

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 09:16:42 GMT

you will get the output you require with the expression I provided earlier -

=Date(Date#('09-Jun-2017','DD-MMM-YYYY'),'MMM-YYYY')

replace the date in expression '09-Jun-2017' with your date field

replace the 'DD-MMM-YYYY' with the current format of your date field .

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 09:17:29 GMT

what is the format of your due date ?

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 09:20:49 GMT

=Date(Date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY')

replace the highlighted with the format of your Due Date field.

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:21:00 GMT

ex: 12-06-2017

Re: how to get date format

kamal_sanguri — Fri, 09 Jun 2017 09:27:21 GMT

Use this-

=Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YYYY')

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:30:48 GMT

this is the output i got

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:32:31 GMT

srrry kamal due date format is yyyy-mm-dd

Re: how to get date format

qlikview979 — Fri, 09 Jun 2017 09:34:14 GMT

Hi,

Can you please share the sample data

Regards

Re: how to get date format

shanky1907 — Fri, 09 Jun 2017 09:47:31 GMT

What format is of your Input Date? Please Accordingly use the Current Format in the Date#() funtion.

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:50:16 GMT

hi ,

Date(Date#([Due Date],'2017-Jun-09'),'MMM-YYYY')as MonthYear1

i am using this and out u can see above which i got but i am looking for attached pic output how can i achieve that.

thanks,

Re: how to get date format

qlikview979 — Fri, 09 Jun 2017 09:52:59 GMT

Hi Pradeep,

Please provide the sample input data format that is easy for us.

Re: how to get date format

sannidhikumar — Fri, 09 Jun 2017 09:54:43 GMT

mahesh ,

sorry due to security reason i cant submit the sample .

please send me logic i can understand .

thanks ,