T
Tim Peterson
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.
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.