Query Date & Time merge & calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Tried this but FullDate does seem to be recognised within the Expresssion
Builder ?

John Spencer said:
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.


Paul Dennis said:
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?
Click to expand...
Click to expand...
 
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())




Paul Dennis said:
Tried this but FullDate does seem to be recognised within the Expresssion
Builder ?

John Spencer said:
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.


Paul Dennis said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top