OBDC Data Formatting

J

Jonathan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher is filling blank lines with data 2
Date Formats 4
Forcing a date entry format of dd/mm/yyyy 1
Date Format 10
Extracting just the time portion 6
date 1
COnverting Weeks into Month (text data) 1
date format 6

Top