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.
David