Date format in query export.

[Hansplay]

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.

 

[Duane Hookom]

Are you certain the field is a date field and not text?

Duane Hookom
MS Access MVP

 

[Hansplay]

The data type in the table for this field is "Date/Time" and the format is
'Medium Date".

Thanks

Are you certain the field is a date field and not text?

Duane Hookom
MS Access MVP

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.

 

[John W. Vinson]

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.

 

[Hansplay]

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.

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.