Date format in Smartlist Excel reports

(0) Share

Report

Posted on by Linda Davis

130

I am using Smartlist Builder->Excel Report Builder. When I run a report to Excel, the date format is showing as MM-YYYY-DD. I am not able to reformat using the Excel Report Builder as the option (->) on the report window is greyed out. I seem to be able to reformat text and numeric fields but not dates.

When I look at the SQL script for this Excel Report there is a CAST command to format the date as MM-YYYY-DD even though I have not put any in my report.

How can I correct this and get the date in the correct format of YYYY-MM-DD.

*This post is locked for comments

All responses (2)

Answers (1)

Suggested answer

Linda Davis 130 on at

Like (0)

Report

Re: Date format in Smartlist Excel reports

Worked!! Thank you.
Verified answer

Mike Smith 6,840 on at

Like (0)

Report

Re: Date format in Smartlist Excel reports

Linda,

Try setting-up a Calculation with a CONVERT in it.

This will give you a YYYY-MM-DD with time, there may be other options though: