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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help! date showing as 1900/01/00 2
Problem inserting time values from Access into SQL Server 5
Error in Excel date calculations 3
Check box creates a new record when clicked??? Huh??? 3
Copied Date Changes When Pasted Into Excel 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
How to enter start and end date/time in excel based on some specific value. 7
TimeStamp in SQL 2

Back
Top