May 13, 2003 #1 albyh Technical User Joined May 10, 2003 Messages 32 Location GB I need my table to automatically insert todays date in the follwing format. 130503 Any help would be GREATLY appreciated. Alban
I need my table to automatically insert todays date in the follwing format. 130503 Any help would be GREATLY appreciated. Alban
May 13, 2003 #2 danvlas Programmer Joined Jul 30, 2002 Messages 2,446 Location RO Day(Date) & Format(Month(Date), "00" & Format(Date, "yy" But why this format? The reverse order would make more sense... Daniel Vlas Systems Consultant http://www.geocities.com/danvlas/AutoMail.html Upvote 0 Downvote
Day(Date) & Format(Month(Date), "00" & Format(Date, "yy" But why this format? The reverse order would make more sense... Daniel Vlas Systems Consultant http://www.geocities.com/danvlas/AutoMail.html
May 13, 2003 1 #3 GHolden Programmer Joined May 28, 2002 Messages 852 Location GB 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" 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" in the default value. There are two ways to write error-free programs; only the third one works. Upvote 0 Downvote
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" 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" in the default value. There are two ways to write error-free programs; only the third one works.
May 13, 2003 Thread starter #4 albyh Technical User Joined May 10, 2003 Messages 32 Location GB This was exactly what i was looking for Thanks a lot Alban Upvote 0 Downvote