Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
date(yourfield, 'MMM DD, YYYY')
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
Hi,
You can try:
Date(Day_date,'MMM DD, YYYY')
Regards,
GJ
The least standard but most flexible solution 🙂
=month(Day_date) &' ' & day(Day_date) & ',' & year(Day_date)
Regards,
Robert
Hi,
You can use some thing like this if you want for only perticular date like today
=Date(today(),'MMM DD,YYYY')
Rgds
Anand
Yes, if you add a text object with this statement you have your answer
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