Automatically insert date without / 1

[albyh]

I need my table to automatically insert todays date in the follwing format.

130503

Any help would be GREATLY appreciated.

Alban

 

[danvlas]

Day(Date) & Format(Month(Date), "00&quot & Format(Date, "yy&quot

But why this format?

The reverse order would make more sense...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[GHolden]

If you want to have the date in the format ddmmyy you will need to set the data type to text and put

=Format(Date(),"ddmmyy&quot

in the default value for the field in design view for the table.

If you set the field to a Date/Time data type the closest you will get is dd/mm/yyyy (short date)

and use

=Format(Date(),"dd mm yy&quot

in the default value.



There are two ways to write error-free programs; only the third one works.

 

[albyh]

This was exactly what i was looking for

Thanks a lot

Alban