Formatting date

[Anonymous]

Any idea to make it to display as in red text? I'm using system default autoCalendar.YearMonth.

[Chanty4u]

No i think 

[PrashantSangle · Accepted solution]

Date(DateFieldName,'MMM-YYYY')

or monthName(DateFieldName

Regards

[Anonymous]

I've done it with

=Date(Monthname([Goods Receipt Date]),'MMM-YY')

[Anonymous]

Done thanks for the effort

[Anonymous]

thanks for the effort

[Chanty4u]

it will change entire datefield right?   he need only 3 values ?  correct me if i m wrong

[Anonymous]

the 3 vales only example, i need entire datefield.

[tresesco]

Even if that is the case, one could use conditional expression like:

If(Date=..., Date(Date, <format1>), Date(Date, <format2>) )

[Chanty4u]

Actually i thought  two times he want to show  for that particular red color months   so i said no

If(Date=..., Date(Date, <format1>), Date(Date, <format2>) )    this will work  but in each and every place the same way  it will show right ?.