Adnan Zamurred Posted May 7, 2020 Posted May 7, 2020 Hi When I export the report into excel, the date appears like '06 05 2020 16:02' which excel does not like. Is there a way in Hornbill to change the date format in the reports? Regards
David Hall Posted May 7, 2020 Posted May 7, 2020 Hi @Adnan Zamurred Thanks for the post. I'm guessing you are talking about the request list export of requests? (If not then please let me know) If it is the request list export then the exported dates should use your date/time format settings from your profile settings during export, so it may be a case of altering those settings to a format that you want to use for your export. Kind Regards, Dave.
Adnan Zamurred Posted May 7, 2020 Author Posted May 7, 2020 Ho @David Hall Thank you for your response. I've created a report from the service manager using the requests table and filters accordingly. When I generate the report and download it, the date format is like this 06 05 2020 16:02. Looking to schedule the reports to be created and would be much easier if the date is in the correct format which prevents having to play around with it in Excel. Exporting the request list is perfect and in the correct format as per my profile.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now