see the issue date & due date come wrong
Format those cells as Date.
That 5-digit number starting with a 4 actually is a date value, or a datetime when there is a decimal. That’s how date/datetime values are stored in spreadsheets. It’s the number of days since Jan 1st 1970. The cells in the output file just need formatted as date or datetime for them to display properly. I imagine this would need to be done for every single output file.
Perhaps you want the dates/datetimes to be output as a text value, that is already formatted how you want it to be? For that, use TEXT() in the template, such as TEXT( [date] , “YYYY-MM-DD” )
1 Like
thank you so much
1 Like