date formats
I am using Access 2003 to gather accounting data and create a table that is
exported to a text file for transmission via the internet. The web
application requires the date format to be MM/DD/YYYY. The accounting data
and the Access Short Date Format use single digit month and days if month or
day <= 9.
Is there a quick way to ensure that data is always converted to MM/DD/YYYY
format ? I suppose that I can write code or create fields in my query for
text strings representing two digit months and days and concatenate them
together in a separate field, but I am checking to see if there is an easier
way.
.
Relevant Pages
- Re: Accounting changes
... Right now, the first field of the acct structure is the name of the command, which will always be a non-nul string, so always have a first character non-nul. ... This would provide backwards compatibility for reading old accounting data, which I would think would generally be desirable, and allow us to explicitly version the file in the future. ... Every time we change the type of a field of acct.h we will have to add architecture-specific code in the legacy file reading module. ... The approach I favor is to add to lastcomm an option to dump an accounting file in text format, and a second option to read text accounting data from stdin and write it out in the current accounting file format. ...
(freebsd-arch) - Re: Accounting changes
... Right now, the first field of the acct structure is the name of the command, which will always be a non-nul string, so always have a first character non-nul. ... This would provide backwards compatibility for reading old accounting data, which I would think would generally be desirable, and allow us to explicitly version the file in the future. ... Every time we change the type of a field of acct.h we will have to add architecture-specific code in the legacy file reading module. ... file in text format, and a second option to read text accounting data from stdin and write it out in the current accounting file format. ...
(freebsd-arch) - Negative numeric data in parens in Excel but as minus in Access
... I am taking accounting data from Excel into Access to create reporting ... I want as the format in both. ... Prev by Date: ...
(microsoft.public.access.externaldata) - Re: date formats
... Where do you need to do this formatting: in VBA, ... > application requires the date format to be MM/DD/YYYY. ... > and the Access Short Date Format use single digit month and days if month ... > together in a separate field, but I am checking to see if there is an ...
(microsoft.public.access.queries) |
|
