Thread: Date Question
View Single Post
  #11  
Old September 10th, 2009, 05:22 AM posted to microsoft.public.access.tablesdbdesign
paduanow
external usenet poster
 
Posts: 20
Default Date Question

Where do I put the Format command?
--
pad


"paduanow" wrote:

I need to store todays date in a table with the following format:

yyyy,mm,dd

Example: 20090914 (09/14/2009 I need this lead zeros, my store 8
digits/char)

Default will always be todays date. Should the field be a date/time field
or a text field with a string conversion routine that puts it on the required
format?

I will never display this date in a form or report.


--
pad