Here’s some back ground just in case.
I have a volunteer table with lots of info. I’m only using the FName, Lname, Email and DateTime fields. What I’m doing is making a method to track each volunteer. I have a form for the volunteer to enter his first and last name (FName & Lname) and to store the current date and time (CurrDate & CurrTime) then the user clicks a button to sign in. When the button is clicked the volunteer table is searched for the FName , LName from the form and when found compares the date and time in the table to the current date and time on the form.
The problem I’m having is the volunteer table has the date and time stored as text like this:
Sat 05-May 10:30AM to 12:30PM
Sun 25-Mar 12:30PM to 2:30PM
Days are only
Sat or Sun
Times are only
10:30AM to 12:30PM
12:30PM to 2:30PM
2:30PM to 4:30PM
I’m thinking I need to change the CurrDate and CurrTime to text and then compare them to pieces of the DateTime in the table. But I can’t seem to get it right. Also there is a problem with the time not matching as the sign in may be early or late and I would need to set a range of times to compare. i.e. if the sign in was at 10:15AM for the 10:30 time slot a search criteria would need to be something like 10:00AM to 11:00AM = 10:30AM.
Any thought or ideas would be great.
Thanks in advance
Paul
I have a volunteer table with lots of info. I’m only using the FName, Lname, Email and DateTime fields. What I’m doing is making a method to track each volunteer. I have a form for the volunteer to enter his first and last name (FName & Lname) and to store the current date and time (CurrDate & CurrTime) then the user clicks a button to sign in. When the button is clicked the volunteer table is searched for the FName , LName from the form and when found compares the date and time in the table to the current date and time on the form.
The problem I’m having is the volunteer table has the date and time stored as text like this:
Sat 05-May 10:30AM to 12:30PM
Sun 25-Mar 12:30PM to 2:30PM
Days are only
Sat or Sun
Times are only
10:30AM to 12:30PM
12:30PM to 2:30PM
2:30PM to 4:30PM
I’m thinking I need to change the CurrDate and CurrTime to text and then compare them to pieces of the DateTime in the table. But I can’t seem to get it right. Also there is a problem with the time not matching as the sign in may be early or late and I would need to set a range of times to compare. i.e. if the sign in was at 10:15AM for the 10:30 time slot a search criteria would need to be something like 10:00AM to 11:00AM = 10:30AM.
Any thought or ideas would be great.
Thanks in advance
Paul
