Today's date in Access
From: James (anonymous_at_discussions.microsoft.com)
Date: 06/20/04
- Next message: Focus: "corrapted database when computer shut down"
- Previous message: steve: "Re: date"
- Next in thread: Nick Coe \(UK\): "Re: Today's date in Access"
- Reply: Nick Coe \(UK\): "Re: Today's date in Access"
- Reply: Steve Schapel: "Re: Today's date in Access"
- Reply: Albert D. Kallal: "Re: Today's date in Access"
- Reply: Dirk Goldgar: "Re: Today's date in Access"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 20 Jun 2004 00:10:17 -0700
How can I use a form button to insert today's date in a
table, to leave a transction log?
I have tried putting the current date in a SQL string
that I run with doCmd in VBA, but if the data type in the
table is date/time, I get rubbish (31/12/1899, or some
such). It looks OK if I change the data type in the
table to string, but I need it to be a date type for
calculation.
This would be dead easy in Oracle.
Thanks
James
- Next message: Focus: "corrapted database when computer shut down"
- Previous message: steve: "Re: date"
- Next in thread: Nick Coe \(UK\): "Re: Today's date in Access"
- Reply: Nick Coe \(UK\): "Re: Today's date in Access"
- Reply: Steve Schapel: "Re: Today's date in Access"
- Reply: Albert D. Kallal: "Re: Today's date in Access"
- Reply: Dirk Goldgar: "Re: Today's date in Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|