G
GaryDennis
How could I set a Form or Table's Default date to prior the month in month
and yearformat e.g.(May- 05)?
Thank you,
Gary
and yearformat e.g.(May- 05)?
Thank you,
Gary
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Prior month --
Date()-Day(Date())
Set format property as mmm- yy for 3 character month and 2 digit year.
Use mmmm yy for full spelling of month and 2 digit year.
Date()-Day(Date())
Set format property as mmm- yy for 3 character month and 2 digit year.
Use mmmm yy for full spelling of month and 2 digit year.
K
Klatuu
Simple, straigtforward way:
=Format(Dateadd("m", -1, MyDate), "mmmm")
=Format(Dateadd("m", -1, MyDate), "mmmm")
K
Klatuu
Sorry, left part off
=Format(Dateadd("m",-1,MyDate),"mmmm") & " - "& Format (Dateadd("m", -1,
#1/15/2005#), "yy")
=Format(Dateadd("m",-1,MyDate),"mmmm") & " - "& Format (Dateadd("m", -1,
#1/15/2005#), "yy")
G
GaryDennis
Karl,
Thank you, I appreciate the help!
Thank you, I appreciate the help!
G
GaryDennis
Klatuu
Thank you very much for the help! I appreciate it!
Gary
Thank you very much for the help! I appreciate it!
Gary
G
GaryDennis
Sorry, Karl, I replied to you another Klatuu's name.
Thank you!
Thank you!