Default date format ?

[Guest]

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

 

[Guest]

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.

 

[Guest]

Simple, straigtforward way:
=Format(Dateadd("m", -1, MyDate), "mmmm")

 

[Guest]

Sorry, left part off

=Format(Dateadd("m",-1,MyDate),"mmmm") & " - "& Format (Dateadd("m", -1,
#1/15/2005#), "yy")

 

[Guest]

Karl,

Thank you, I appreciate the help!

 

[Guest]

Klatuu

Thank you very much for the help! I appreciate it!

Gary

 

[Guest]

Sorry, Karl, I replied to you another Klatuu's name.

Thank you!