Data function won't work...

[105ben]

Hello,

This date function should return the date and time from exactly one month ago, any ideas as to why it wont??

=DateAdd("mm",-1,Date())+Time()

 

[John Big Booty]

Try;

=[URL="http://www.techonthenet.com/access/functions/date/dateadd.php"]DateAdd[/URL]("m",-1,[URL="http://www.techonthenet.com/access/functions/date/now.php"]Now()[/URL])

Use the Now() function (which includes a time component) rather than the Date() function (which doesn't).

Also month is "m" rather than "mm"

 

[105ben]

Thank you!