Hello , 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 Please advise. Thanks Madhavi

Hi, 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") good luckThink out of the box

I like Format(today(),"MMM yyyy") that would be the right choice.Please mark ANSWERED if my reply contributed to your solution.