 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / December 2005Query Date & Time merge & calculate
I have a date field and a time field which I need to merge together to be used in a date/time comparison - any ideas how? Add them together? Field: FullDate: [DateField] + [TimeField] Note that this will give you a null value if either one of the two fields is null. >I have a date field and a time field which I need to merge together to be > used in a date/time comparison - any ideas how? Tried this but FullDate does seem to be recognised within the Expresssion Builder ? > Add them together? > [quoted text clipped - 5 lines] > >I have a date field and a time field which I need to merge together to be > > used in a date/time comparison - any ideas how? It won't be. If you are doing this in an expression, you have to use the formula every place you think you need FullDate. Something like DateDiff("n",[DateField] + [TimeField],Now()) > Tried this but FullDate does seem to be recognised within the Expresssion > Builder ? [quoted text clipped - 10 lines] >> >be >> > used in a date/time comparison - any ideas how? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.