Exporting reports with converted date
Hi Is there a way to export reports from QB with a converted date format dd-mm-yyyy? Currently the report shows - Month Name - dd - yyyy But when I export the Report it converts the date to mm...
Forum Discussion
Hi Austin
I would like it to be simple date - dd/mm/yyyy
------------------------------
Jessica Matenga
------------------------------
I would like it to be simple date - dd/mm/yyyy
------------------------------
Jessica Matenga
------------------------------
I am a little confused here. From your initial post it sounded like the issue was it was in the format of Name-dd-yyyy and when exporting it you were receiving it in mm-dd-yyyy which was not the desired effect.
Is the format you want dd-mm-yyyy then or do you want dd/mm/yyyy? How is it currently showing up when exporting it?
When you go to the properties of the date field do you have "show month as name" checked?
Is the format you want dd-mm-yyyy then or do you want dd/mm/yyyy? How is it currently showing up when exporting it?
When you go to the properties of the date field do you have "show month as name" checked?