Date format ??

[sushil353]

Hi All,

I have a field Day_date in 10/8/2011 format (MM/DD/YYYY)

i want to show it using a text object in Sep 8, 2011 format...

Please suggest how can i achieve this....

Thanks

Sushil Kumar

[Michiel_QV_Fan]

date(yourfield, 'MMM DD, YYYY')

[its_anandrjs · Accepted solution]

Hi,

You have to change date format like

10/8/2011 format (MMM D/YYYY)

use this code to change format =Date(DateField,'MMM D,YYYY')

See the attached sample file.

HTH

Rgfds

Anand

[#4]

Hi,

You can try:

     Date(Day_date,'MMM DD, YYYY')

Regards,

GJ

[#5]

The least standard but most flexible solution 🙂

=month(Day_date)   &' '  &  day(Day_date)  & ',' &  year(Day_date)

Regards,

Robert

[its_anandrjs]

Hi,

You can use some thing like this if you want for only perticular date like today

=Date(today(),'MMM DD,YYYY')

Rgds

Anand

[Michiel_QV_Fan]

Yes, if you add a text object with this statement you have your answer

[its_anandrjs]

Hi,

If you want to display perticular date from date filed like Day_date so put some condition like

If(  Day_date = 10/8/2011, Date(Day_date, 'MMM D,YYYY' )

Rgds

Anand