Toad World® Forums

Change date/time to date only for use in Pivot Grid

I am trying to create a pivot grid from a Excel log file that contains a date/time field with format ‘25/01/2012 22:09:32’.

How do I convert the date/time field in TDA to Date only ‘25/01/2012’, so my pivot grid can display a count per day?

I know I could do this in Excel first, but my goal is to automate a TDA report from a daily received source log file (in Excel format).

Thank you in advance.


I would connect to the excel sheet and use SQL to change the format. Then use that SQL in a Toad Pivot Grid. The Toad Pivot Grid can be used in automation.