Hi Everyone,
I got a problem with this code. DateDiff('h',[DateInstalled],[=Date()])
I don't want it to appear in the new line.
The following code unable to auto update the date.
Any idea that i can update the existing date that i keyed?
Thanks
Hi Everyone,
I got a problem with this code. DateDiff('h',[DateInstalled],[=Date()])
I don't want it to appear in the new line.
The following code unable to auto update the date.
Any idea that i can update the existing date that i keyed?
Thanks
Can you give us a clearer explanation of what you are trying to do
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Shouldn't have the equals sign nor the brackets around the date function.DateDiff('h',[DateInstalled],[=Date()])
Try
The brackets tell access that it is a field name..Code:DateDiff('h',[DateInstalled],Date())
Hi ssanfu,
Thanks for your help. My programme able to works.
Best Regards
Jeremy Sng