K
Krish
I am trying to import external data into Excel spreadsheet. One of the
tables in the external data has a field "Time" for Date and time of
transaction. In MS query I inserted a new column with a new name and
inserted a formula Left(Filename.Time,11). The result came as "Dec 2,2003",
whereas I wanted this to show as "12/02/2003", in the true date format..
What function I should use to get the desired result from MS Query.
Thank you all for the help.
Krish
tables in the external data has a field "Time" for Date and time of
transaction. In MS query I inserted a new column with a new name and
inserted a formula Left(Filename.Time,11). The result came as "Dec 2,2003",
whereas I wanted this to show as "12/02/2003", in the true date format..
What function I should use to get the desired result from MS Query.
Thank you all for the help.
Krish