August 21, 2013 at 12:34 pm
I want to display date as "June,2013" - Two months from the current month,year.
Is there an expression I can use?
August 21, 2013 at 1:30 pm
Hi
you can use this two methods:
monthname() and year()
for example:
=monthname(month(Today))+","+cstr(year(Today))
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
August 21, 2013 at 1:35 pm
Worked!
Great. Thank you.
August 21, 2013 at 1:40 pm
your welcome 🙂
good luck on your work
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
August 21, 2013 at 1:41 pm
An alternative is using the format functions.
A list with predefined formats can be found here:
Predefined Date/Time Formats (Format Function)
The one you need would be Y,y.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply