How to display the date format as customization format

[ravindraa]

Hi all,

  I have struck in one place please help me out to come out form that ,In my data model my date format like this (MM/DD/YYYY)  but i need to display the the date format like below (Jan DD)  please give me suggestion on this to come out.

Thanks in advance.

Thanks &Regards

Ravindra

[Anonymous]

use Date() function like:

Date(YourDateFiled, 'DD MMM YYYY') as YourDateFiled

[Anonymous]

For your case:

Date(YourDateFiled, 'MMM DD') as YourDateFiled

[elakkians]

Try this

in Expressions:

=Date(Fieldname,'MMM DD')

in Script:

Date(Fieldname,'MMM DD') as Fieldname

[ravindraa]

Hi Balaraj,

Thank you for replay but i have tested in same way but i am getting like below values

I am getting year also including month and date please give me suggestion what mistake i did.

Thanks in advance...............

[Anonymous]

could you share some data sample??

[Anonymous · Accepted solution]

see the attachment, its working fine...

[tamilarasu]

Hi Rvindraa,

Try,

=Date(Date#(YourField,'MM/DD/YYYY'),'MMM DD')

[ravindraa]

Hi Balaraj,

Just now i have tested with sample data ,now it is coming but with data base data it is not coming .Do you have any idea in what type of senario' it is not working .

thanks in advance.

[Kushal_Chawda]

try,

date(date#(MonthName_Day,'MMM YYYY DD'),'Needed Format')