View Full Version : user enters date; other dates calculated


donnycarr
10-11-2001, 01:47 AM
I have created a text box on the form, formatted to Date/Time and with an Input Mask where the user inputs a certain date).

I now want to create some "boxes??" next to this with calculations to work out a date 4, 12 and 52 weeks previous to the date entered by the user. I will then get the queries to pick up these dates from the various boxes in order to select certain records.

If anyone can help it would be much appreciated, I am really struggling with this..

Thanks

...Donny

Rich
10-11-2001, 03:04 AM
Look up the DateAdd Function there are many examples shown in the help files.
HTH