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 |
#1
|
|||
|
|||
Date format in query export.
I am exporting a query to a .csv file. In a Date field I formatted as so:
FormattedActivityDate: Format([Activity Date],"yyyy/mm/dd") The date in the .csv file shows up in the format, "m/dd/yyyy". Anyone know what I am doing wrong? Thanks. |
#2
|
|||
|
|||
Date format in query export.
Are you certain the field is a date field and not text?
Duane Hookom MS Access MVP "Hansplay" wrote in message ... I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format([Activity Date],"yyyy/mm/dd") The date in the .csv file shows up in the format, "m/dd/yyyy". Anyone know what I am doing wrong? Thanks. |
#3
|
|||
|
|||
Date format in query export.
The data type in the table for this field is "Date/Time" and the format is 'Medium Date". Thanks "Duane Hookom" wrote: Are you certain the field is a date field and not text? Duane Hookom MS Access MVP "Hansplay" wrote in message ... I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format([Activity Date],"yyyy/mm/dd") The date in the .csv file shows up in the format, "m/dd/yyyy". Anyone know what I am doing wrong? Thanks. |
#4
|
|||
|
|||
Date format in query export.
On Tue, 9 Feb 2010 13:32:05 -0800, Hansplay
wrote: I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format([Activity Date],"yyyy/mm/dd") The date in the .csv file shows up in the format, "m/dd/yyyy". Anyone know what I am doing wrong? Thanks. Access ignores the format property of a field in the export. Are you certain that you're exporting the text string generated by the Format() function call? or perhaps the export is exporting the actual date/time field? Perhaps you could post the SQL of the query that you're exporting. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Date format in query export.
John, here is the SQL of the query.
SELECT tblLabourTransaction.[CWA Number], tblLabourTransaction.[SubContractor ID], [My Company Contract #] & "-" & Format([ReferenceNumber],"000000") AS ContractorReferenceNumber, Format([Customer Employee ID],"00000") AS [Client Employee ID], Format([ActivityDate],"yyyy/mm/dd") AS FormattedActivityDate, tblLabourTransaction.AccountCode, tblLabourTransaction.[Reason Code], tblLabourTransaction.Hours, tblLabourTransaction.[Work Order], tblLabourTransaction.CraftCode, tblLabourTransaction.Schedule, tblLabourTransaction.[Cost Center], tblLabourTransaction.Activity, tblLabourTransaction.[Equipment ID], tblLabourTransaction.[End User Signoff], tblLabourTransaction.[Activity Description] FROM tblLabourTransaction WHERE (((tblLabourTransaction.[Batch Number])=[Forms]![frmExportMenu]![cmboBatchtoExportLab])); Thanks. "John W. Vinson" wrote: On Tue, 9 Feb 2010 13:32:05 -0800, Hansplay wrote: I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format([Activity Date],"yyyy/mm/dd") The date in the .csv file shows up in the format, "m/dd/yyyy". Anyone know what I am doing wrong? Thanks. Access ignores the format property of a field in the export. Are you certain that you're exporting the text string generated by the Format() function call? or perhaps the export is exporting the actual date/time field? Perhaps you could post the SQL of the query that you're exporting. -- John W. Vinson [MVP] . |
Thread Tools | |
Display Modes | |
|
|