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]

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

[kamal_sanguri]

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

[sujeetsingh]

Expression seems okay. just check the data types.

[Peter_Cammaert]

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?

[qlikcheepirishe]

Hiii pradeep,

please find attachment below.

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

[sannidhikumar]

hi All ,

thanks for reply i need out put as like this .

[sannidhikumar]

due date is field name i am using .

[kamal_sanguri]

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 .

[kamal_sanguri]

what is the format of your due date ?