May 7, 2012 at 4:02 pm
Okay, this one really does have me stumped. In a header field, I want to use an expression to display today last year in MMMM dd, yyyy format.
MMMM dd, yyyy.
I get an error when I try this:
=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))
I get 5/7/2011 12:00:00 AM (which isn't the format I want) when I try this:
=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))
Would anyone know what I'm doing wrong? Thanks, as always, for the help.
May 9, 2012 at 9:49 am
DataAnalyst110 (5/7/2012)
Okay, this one really does have me stumped. In a header field, I want to use an expression to display today last year in MMMM dd, yyyy format.MMMM dd, yyyy.
I get an error when I try this:
=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))
I get 5/7/2011 12:00:00 AM (which isn't the format I want) when I try this:
=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))
Would anyone know what I'm doing wrong? Thanks, as always, for the help.
This should work:
=Format(DateAdd(DateInterval.Year, -1,Now()), "MMMM dd, yyyy")
gsc_dba
May 9, 2012 at 2:35 pm
Yep, that works just right. Thanks so much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply