Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SetValue Getdate()
Excellent! Works like a dream!- alniagara
- Post #5
- Forum: Microsoft: Access Project (ADP)
-
SetValue Getdate()
Hi, Thanks but tried both and Access returns the error that it can't parse either of the expressions Set Value - ContactDate - Date(Now()) or Set Value - ContactDate - Date(Today()) Can anyone help with an alternative way of doing this?- alniagara
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
SetValue Getdate()
Hi I'm building a SQL Server 2000 database with an Access 2003.adp front end and I need a simple way to set todays date in a field when the user requires it. In Access MDB the expression is Now(), in SQL it's GETDATE() so have tried both in the following macro. SetValue - ContactDate -...- alniagara
- Thread
- Replies: 4
- Forum: Microsoft: Access Project (ADP)
