i usually use formatdatetime(sysdate,2) to only show date.
But now i want to display someting like this..
Qtr Ending Jan 2012
how to i format the datetime to get Jan 2012
You can use
=MonthName(Month(Today())) &" " & Year(Today())
Please mark ANSWERED if my reply contributed to your solution.
Or, you could use:
="Qtr Ending " & Format(today(),"MMM yyyy")
Think out of the box
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?