[AccessD] Comparing date and time

Susan Harkins ssharkins at gmail.com
Fri Nov 23 07:59:56 CST 2007


If the users insist on entering the date and time in two different fields, 
which I know, is totally common -- entering them together is a bit 
unnatural -- but this might be one of the few times when it's easier to 
break the rules of normalization and create a composite field in the 
underlying table that combines than two than to try to work with them 
separately. Just a thought.

Susan H.


>I think that you can do this by doing a DateAdd() to the date field itself,
> since without a time specified it will default to midnight. Therefore a
> DateAdd() using the number of minutes indicated by the time ought to 
> produce
> a genuine datetime value.




More information about the AccessD mailing list