how to get date formate like Jan 14,Feb 14..etc??

[balasundaram]

what is the condition for that

[ashfaq_haseeb · Accepted solution]

Hi,

Assuming that you have proper date field.

Then try below

Date(Datefield,'MM YY') as Date --> output 01 14

Date(Datefield,'MMM YY') as Date --> output JAN 14

Regards

ASHFAQ

[balasundaram]

its showing 04 14

but i want Apr 14

[ashfaq_haseeb]

Ok,

Can you post some sample data.

Try this instead

date(Date,'MMM YY')

Regards

ASHFAQ

[ashfaq_haseeb]

Try this

Date(Datefield,'MMM YY') as Date

Regards

ASHFAQ

[aveeeeeee7en]

Hi

You can achieve the desired result using following ways:

1) MonthName(YourDateField) AS Month_Year

2) Subfield(MonthName(YourDateField),' ',1)&' '&Right(Subfield(MonthName(YourDateField),' ',2),2) As Month_Year_New

3) Date(YourDateField,'MMM YY') AS Month_Year_New2

Add them in your Backend Script and Reload the Application. After Reload, use these fields in the Front end. You'll get the expected result.

Also, see the Attachment.

Hope that helps you.

Regards

Aviral Nag