R
Rich
The problem that I am having is that I cannot verify a
date or a time entry. Part of the problem is due to the
way Outlook fails/handles dates and times.
If you have ever used a date or time field you will notice
that no matter what formatting option you use the date
field always consists of the date and the time. This makes
it difficult to print just the date or just the time.
Here is what I have done so far:
I use a date field to recieve the information from the
user.
I use a seperate text field to strip either the time or
the date from the information using the following code:
Format([06 1st Choice Begin] , "hh:nn AM/PM")
Format([06 1st Choice Begin] , "mm/dd/yyyy")
This at least gives you either the date or the time
stripped out.
I still cannot find a way to verfiy that the times or
dates are within a range. For example I need times between
4:00 am and 10:30 pm and dates from 1/2/04 through
12/31/04.
Any help would be greatly appreciated.
Thank you in advance
date or a time entry. Part of the problem is due to the
way Outlook fails/handles dates and times.
If you have ever used a date or time field you will notice
that no matter what formatting option you use the date
field always consists of the date and the time. This makes
it difficult to print just the date or just the time.
Here is what I have done so far:
I use a date field to recieve the information from the
user.
I use a seperate text field to strip either the time or
the date from the information using the following code:
Format([06 1st Choice Begin] , "hh:nn AM/PM")
Format([06 1st Choice Begin] , "mm/dd/yyyy")
This at least gives you either the date or the time
stripped out.
I still cannot find a way to verfiy that the times or
dates are within a range. For example I need times between
4:00 am and 10:30 pm and dates from 1/2/04 through
12/31/04.
Any help would be greatly appreciated.
Thank you in advance