Date format headache (1 Viewer)

[SmallTime]

Hi,

I'm drawing data for a report from SQL-Server via a pass-through query.

The date fields are showing as yyyy/mm/dd whereas I need them to be displayed as dd/mm/yyyy.

If using an ordinary select query know I could use something like;
=Format([datefield],"dd/mm/yyyy"). However, there's no way of doing this in a PT query (that I know of) and SQL doesn't have a formatDate function.

I could draw the data into a temp table or access query and format from there but that seems like a lot of overhead especially for a large number of records.

I'm sure that I'm not the first person to have crashed into this issue and be grateful to hear how others handled it.

Regards
SmallTime

 

[spikepl]

what difference does it make what date format shows in the table/query?You can format to your heart's content in the controls bound to the fields of the record source

 

[SmallTime]

Methinks my brains turned to mush

 

[spikepl]

Too much mush mush have done it