date field

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello Everyone,

I need two text boxes in a form to display todays date but in two
formats one (dd mm yy) and (dd mm y).


TIA,
David
 
David said:
Hello Everyone,

I need two text boxes in a form to display todays date but in two formats one
(dd mm yy) and (dd mm y).
Click to expand...

Use a ControlSource for both of =Date() and then set the format properties to...

dd mm yy
dd mm y
 
Thanks Rick I tried that previously and the results were 20 02 51 the
other format dd mm yy works fine though. I just needed a single digit
for the year/
 
In the context of Format, y displays the day of the year as a number (1 -
366), not the year.

You'll have to write your own function to give you the format you want.
 
Back
Top