I have a (date) column “Date Worked” and also a Start Time column (DateTime).
I want to require the Start Time column (DateTime) to be = to the Date Worked column (date).
Date Worked = 5/22/24 therefore Start Time needs to be greater than or equal to 5/22/24 0:00AM. It CANNOT be 5/21/24 at 11:59 pm or before and cannot be greater than 5/22/24 at 11:59pm. (it must be within the 24 hours of 5/22/24. The Stop Time can be independent but cannot before the start Time. You would think the user would be able to understand this but … apparently, they don’t we have to correct the records all the time.
How can I do this? Since the data type are different. I tried to change the date worked to DateTime but it requires a time to be entered. i cannot use Date Worked as the StartTime for other reason. Vacations, PTO. Any work arounds will be ok too.
Thanks.