Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query using Excel
I am trying to create a Pivot table in Excel, using Microsoft Query linking
to SQL database. SQL stores the date as Date/Time. It becomes impossible to group in Excel using Pivot Table, by date/time. I want to create a record in Microsoft query using the date field, but convert to Date only as dd/mm/yyyy and retain the format as Date and not as Text. I have tried Left(Date,11) and Convert(VARCHAR,1,101), none of them work. Could someone help me with the correct syntax. Microsoft query does not recognize MID. Thanks Krish |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query using Excel
Excel stores dates as Date/Time. If your values are being stored as strings
or you are missing a value, then you won't be able to group. -- Regards, Tom Ogilvy "Krish" wrote in message ... I am trying to create a Pivot table in Excel, using Microsoft Query linking to SQL database. SQL stores the date as Date/Time. It becomes impossible to group in Excel using Pivot Table, by date/time. I want to create a record in Microsoft query using the date field, but convert to Date only as dd/mm/yyyy and retain the format as Date and not as Text. I have tried Left(Date,11) and Convert(VARCHAR,1,101), none of them work. Could someone help me with the correct syntax. Microsoft query does not recognize MID. Thanks Krish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Query in Excel | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Need help with Excel Microsoft Query | Excel Discussion (Misc queries) | |||
SQL Query in Microsoft Excel | Excel Programming | |||
Microsoft Query in Excel | Excel Discussion (Misc queries) |