G
Guest
Hi, I'm trying to do a query that will look at today's date =date() and
compare with a date stored in a table and pull out if they are within 30 days
of each other - either before or after! Is that possible? I can get the no
of days calculated and the difference in days DateDiff but I cannot then pull
out Between And because Criteria won't work on the calculated field DateDiff
- any clues? Many, many thanks Sally T
compare with a date stored in a table and pull out if they are within 30 days
of each other - either before or after! Is that possible? I can get the no
of days calculated and the difference in days DateDiff but I cannot then pull
out Between And because Criteria won't work on the calculated field DateDiff
- any clues? Many, many thanks Sally T