Date Format Inventory Date Creation Date
On the "All Inventory" page, you can add two columns "Creation Date" and "Inventory Date". As long as I look at these on the application page, they all appear fine, and consistent. However, when I download these to an excel/CSV, they all have different formats. So its very difficult to filter on it. Have you experienced this, and is there a fix to it?
Can you give some examples of the formats you are seeing, particularly in the raw CSV data?
I’ve just tried doing a download as described, and in my case the date values are all coming through in a consistent format. For my settings all dates are in dd/MM/yyyy format in both downloaded CSV and Excel files. Here is an example of dates in CSV data I'm seeing:
Backing up what Chris shared, can you define what you mean by 'date format', with visual illustration also? Doesn't sound like something that would be DP oriented and more environmental but let's see.
If you see the sample below, this is exactly what the CSV file is giving me. Some have a "/" as separator, others have a "-" as separator. When I click on the cells, the ones in mm-dd-yyyy are being captured in a "Date" format, while those in MM/DD/YYYY are being captured in a general format. I am unable to filter properly.
Thank Chris, This is the raw output from CSV, and this does look more consistent, but it scrambles when I view in excel. Or even when I download the xslx file. Any ideas what settings I can fix in excel to get this right?
I usually use the Excel import function, instead of opening the CSV file with Excel directly. It helps setting data formats.