Revenue Management > Street Rates > Export Templates > Street Rates by Unit Type Template
bug-verified
R
Randy Fountain
Miljan Kostic Tony Gardner I see. However, that field should not be stored as a date field regardless of the parsing behavior.
M
Miljan Kostic
When exporting data as an Excel file, the values are treated as raw data and are not subjected to any automatic formatting, which is why the value appears correctly (e.g., "10-20"). However, when you open the same data in a CSV file using Excel, Excel automatically applies built-in date recognition and formatting, interpreting values like "10-20" as a date (October 20th, or "10/20").
If you open the CSV file in a text editor, you will see the value as "10-20" (or "3-5" for "3rd of May"), since CSV files store data as plain text without any formatting. But when opened in Excel, due to its date parsing behavior, it converts values like "3-5" to May 3rd.
T
Tony Gardner
Randy Fountain Interesting. I am able to duplicate it, but not in the same way. For my, exporting the ADS template, I am seeing it in the Height column
T
Tony Gardner
bug-verified
R
Randy Fountain
Tony Gardner