Date and Time Inserted into Record

[longbillduck]

I know I can use =Date() to add the date to a new record

But is there a way to add the date and hour & minutes?

Thanks

Art

 

[striker83716]

Use Now() this will give you both the date and time

Rob

 

[Rolliee]

Art,

The now() function returns the date as the integer portion and the time() as the fraction portion - thus int(now()) is the date and fract(now()) the time you are after.

format() is the way to see all this using date. Check out your F1 to see the options.


Rollie

 

[TheStriker]

Hey longbillduck,

You can use Date() if you want the date to update every day or you can use Now() which will "stamp" the record with the current date and time and will not update everyday.

For the hour and minutes to show just choose the correct Date/Time formatting:

General Date = mm/dd/yyyy hh:mm:ss

mm = double digit month
dd = double digit day
yyyy = four-digit year

hh = double digit hour
mm = double digit minute(s)
ss = double digit seconds

Or you can customize it the same way like:

mm/dd/yyyy hh:mm

just make sure you type it just the way you see it in the 'Format' section of the properties.

TheStriker

 

[longbillduck]

Thanks for the help!

Art