Default value previous month

[Guest]

Hi
While defining a date field in a table, i want the date filed's default
value to be
current month-1 (December)
e.g January less 1 = December

Thanks in advance

 

[Rick Brandt]

Hi
While defining a date field in a table, i want the date filed's
default value to be
current month-1 (December)
e.g January less 1 = December

Thanks in advance

Use a default value property of...

DateAdd("m",-1,Date())

 

[Tom Wickerath]

Hi Rony,

See the following KB article:

Functions for calculating and for displaying Date/Time values in Access
http://support.microsoft.com/kb/210604

For example, you can use this:
DateSerial(Year(Date()), Month(Date())-1,1)

Tom
_________________________________


Hi
While defining a date field in a table, i want the date filed's default
value to be
current month-1 (December)
e.g January less 1 = December

Thanks in advance

 

[Guest]

Thanks a lot it helped me

Use a default value property of...

DateAdd("m",-1,Date())

 

[Guest]

Thanks a lot it helped me