If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
Date Question
On Wed, 9 Sep 2009 21:22:03 -0700, paduanow wrote:
Where do I put the Format command? I'd use the Format *function* - not command - in whatever query you use to export the data to the state's formatted file: you can just put ExpDate: Format([datefield], "yyyymmdd") in a vacant Field cell in the query, and then export this query. Don't confuse data STORAGE with data PRESENTATION. They are different tasks! -- John W. Vinson [MVP] |
#13
|
|||
|
|||
Date Question
On Wed, 9 Sep 2009 21:22:03 -0700, paduanow wrote:
Where do I put the Format command? I'd use the Format *function* - not command - in whatever query you use to export the data to the state's formatted file: you can just put ExpDate: Format([datefield], "yyyymmdd") in a vacant Field cell in the query, and then export this query. Don't confuse data STORAGE with data PRESENTATION. They are different tasks! -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|