Click to See Complete Forum and Search --> : date formula for previous month to date


tball222
June 23rd, 2008, 11:55 AM
Greetings all. I am having trouble remembering the formula for previous MTD in subreports. it looks something like this: {MTD Service Table.Date} <= DateTime (2008, 06, 01, 00, 30, 00) to date (-32) but not quite. Can anyone please tell me what I am missing?

Ned Pepper
June 27th, 2008, 03:40 PM
Try
{Table.Date} >= DateAdd("d", -32, #June 27, 2008#)

You may also want to check out the functions
LastFullMonth
and/or
Aged0To30Days