OBDC Data Formatting
 

Hi,

I can't find a NG for ODBC in excel so I hope you can help me? We query a
SQL database that holds dates in the datetime format i.e. dd/mm/yyyy hh:mm:ss.

We normally force formatting on this column to send the data to Excel by
forcing it using +Year, +Month & +Week in our legacy databases now we have
swapped to SQL Query doesn't recognize the function +Week but does the others.

How can I get Query to set the column to diplay the week number once it
returns the data to excel?

TIA