Dates

  • Thread starter Thread starter APH
  • Start date Start date
A

APH

Hi, if I want to enter a date field as dd/mm/yy with the Now(0 function,
but omitting the time, can someone tell me the correct syntax please

I am being very thick today and cannot seem to get it right

Thanks
A
 
Hi,

Try setting the format to dd/mm/yy

set default value to
=format(now(),"DD/MM/YY")

tHINK THIS MIGHT WORK

Regards
 
Hi, if I want to enter a date field as dd/mm/yy with the Now(0 function,
but omitting the time, can someone tell me the correct syntax please
Click to expand...

Use the Date() function instead of the Now() function - it returns
just the date portion.

Note that all date/time fields have a date and a time portion - if you
use Date(), or DateValue([datefield]), that time portion is set to
midnight and suppressed from display in some formats, but it's still
there. The date is stored internally as a double float number, a count
of days and fractions of a day (times) since midnight, December 30,
1899; if the fractional portion is .0000000 it's midnight (and will be
treated as just a date without displaying the time).
 
Back
Top