add date to time value

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

Guest

I need an expression to add a date value to time value in a form control. The
backend is SQL server 2k. I have time values with the date value currently
1/1/1900 and want to replace the 1/1/1900 with a specific date value which is
the value of another control.

Thanks so much!!
 
I'm not sure if you are trying to change the value of the field or just to
display the combination of the two fields in a form, you can try and use this

=DateFieldWithDate & " " & format(DateFieldWithTime,"hh:mm:ss")
 
Thanks Ofer!
I tried to put that in a query field and get a syntax error in the FROM
clause. ANy thoughts?
 
Back
Top