G Guest Dec 1, 2005 #1 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?
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?
J John Spencer Dec 1, 2005 #2 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.
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.
G Guest Dec 2, 2005 #3 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...
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...
J John Spencer Dec 2, 2005 #4 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...
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...
