This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I can't figure out how to output datetime values to excel using the table and render tool, so that excel recognizes the values as a proper date time format, so excel users can build pivot tables using the date time values?
When outputting to excel using table and render tool, opening up the excel file recognises it as a number?
If outputting to excel using the normal output tool, then it works fine.
examples below, appreciate your help,
example test using a text tool with 1 datetime value, along with table and render tool:
example test using text tool with normal output tool