how to get date format

[sannidhikumar]

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 ,

[kamal_sanguri]

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

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

[sannidhikumar]

ex: 12-06-2017

[kamal_sanguri]

Use this-

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

[sannidhikumar]

this is the output i got

[sannidhikumar]

srrry kamal due date format is yyyy-mm-dd

[qlikview979]

Hi,

Can you please share the sample data

Regards

[shanky1907]

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

[sannidhikumar]

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,

[qlikview979]

Hi  Pradeep,

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

[sannidhikumar]

mahesh ,

sorry due to security reason i cant submit the sample .

please send me logic i can understand .

thanks ,