#error when using GetDate()

  • Thread starter Thread starter Geraldine Hobley
  • Start date Start date
G

Geraldine Hobley

Hello,
I'm having a problem binding a default value of
Today's date into a field on a form. It works fine on my
computer (office xp sp 1), but on some computers the field
has a value of #error on loading.

The default value of the field is

CDate(left(GetTodaysDate(), 10))

where the querie in GetTodays date is as below
sql = "select getdate() as todaysdate"

Also using Now() as the default for the text field also
causes a problem on some pcs.

Any idea why this may be a problem on some pcs, or anyone
know any other ways of getting todays date apart from
GetDate() and now().

Thanx in Advance

Geraldine
 
Geralldine,

Ade files still require references and can have missing references because
they are not really executeables as they require Access.exe to run.

Josh
 

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

Ato generated control number 1
GetDate() 2
SQL Upsizing: Invalid use of "getdate" within a function 4
update checkbox when date greater than current. 4
WeekNum Trouble 4
dafault value for date not working with Date() but Now() is workin 3
Issue creating a report from criteria 5
91 object variable or with block variable not set 6

Back
Top