Date Function in Access

[dhen21dx]

Hi Guys,

I need help on calculation of Time in Access. I have a Received Date and Closed Date, i do need to check if the time of Received date is =< 8:00 AM till 4:00 PM, if it is then i need to check if the time of Closing Date is at 5:00 PM (means same day closing) remarks will be Pass, Failed for those closing time 5:01 onwards. For the second validation, if received date time is 4:01 PM onwards, then 24 hours apply and remaks as Pass, if more than 24 hours mark as Failed.

Thanks

 

[xenou]

Perhaps a solution would be a lookup to get starting times/closing times using a country parameter. My code is based on using that information to test for whether or not the fix is on time based on calculating the time it is due. So just something like GetStartTime(TheCountry) and GetCloseTime(TheCountry) instead of the hardcoded values of 8 AM and 5 PM. You should be able to write that yourself.

 

[dhen21dx]

Hi Xenou,

Thanks for helping, i am new on using ms access, will it cover the 4 rules using formula? or i need to have a vba code? how about in USA country where the start and end date is different?, the end date is on the next day 5AM. Hope you can give me idea.

 

[dhen21dx]

Can you give me sample of how can i do that?

 

[dhen21dx]

Hi Xenou,

Hope you can still help me, can Select Case also applicable for the selection of region.


Thanks