Insert date

[Blue Bell Trading - Customer Services]

Hi,

I would like to add the current date, and time if possible, to all records
in a query?

--
Kind Regards,
Customer Services
Blue Bell Trading

[jimfortune]

Blue Bell Trading - Customer Services wrote:

Hi,

I would like to add the current date, and time if possible, to all records
in a query?

--
Kind Regards,
Customer Services
Blue Bell Trading

SELECT Stuff, CDate(Int(Now()) AS theDate, CDate(Now() - Int(Now())) AS
theTime FROM tblData;

James A. Fortune

[jimfortune]

[e-mail] wrote:

Blue Bell Trading - Customer Services wrote:

Hi,

I would like to add the current date, and time if possible, to all records
in a query?

--
Kind Regards,
Customer Services
Blue Bell Trading
SELECT Stuff, CDate(Int(Now()) AS theDate, CDate(Now() - Int(Now())) AS

^
|

) <--- Oops. Insert another ).
theTime FROM tblData;

James A. Fortune

[Douglas J. Steele]

<ji********@compumarc.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Blue Bell Trading - Customer Services wrote:

Hi,

I would like to add the current date, and time if possible, to all
records
in a query?

SELECT Stuff, CDate(Int(Now()) AS theDate, CDate(Now() - Int(Now())) AS
theTime FROM tblData;

If you're going to separate the date and time, why not

SELECT Stuff, Date() AS theDate, Time() AS theTime FROM tblData;

However, why would you separate the date and time? Having them as separate
fields makes querying more complicated. If you have occasion to use only the
date portion, or only the time portion, you can always use the DateValue and
TimeValue functions.

SELECT Stuff, Now() AS theDateTime FROM tblData;
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

[jimfortune]

Douglas J. Steele wrote:

SELECT Stuff, CDate(Int(Now()) AS theDate, CDate(Now() - Int(Now())) AS
theTime FROM tblData;

If you're going to separate the date and time, why not

SELECT Stuff, Date() AS theDate, Time() AS theTime FROM tblData;

However, why would you separate the date and time? Having them as separate
fields makes querying more complicated. If you have occasion to use only the
date portion, or only the time portion, you can always use the DateValue and
TimeValue functions.

SELECT Stuff, Now() AS theDateTime FROM tblData;
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Using just Now() was my first thought, but the comma after date in the
original post seemed to indicate they wanted separate fields. Date()
and Time() as you show are obviously the easier way to do it if
separate fields are desired.

James A. Fortune

[Chuck Grimsby]

Jim,
You may want to take a look at Access' (VBA) Help on the "DateValue"
and "TimeValue" functions.

[jimfortune]

Chuck Grimsby wrote:

Jim,
You may want to take a look at Access' (VBA) Help on the "DateValue"
and "TimeValue" functions.

Thanks Chuck. I had never even looked at those functions before. It
was interesting reading.

James A. Fortune