By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Report Designer
3
Posts
2
Users
2
Reactions
6,533
Views
November 5, 2019 3:13 pm
Hi
I need some help with formatting a date in report designer. The format has to be YYYYMMDDHHMMSS. This is a report that will be exported to Excel and uploaded to the clients bank.
Any help or suggestions would be appreciated.
Thanks so much,
Coleen
2 Replies
November 5, 2019 4:23 pm
Hello @coleen-mcnally
You should be able to stick ='yyyyMMddhhmmss' (This is case sensitive, so copy as is!) into the Format of the textbox on the report to get your dates to look this way.
November 5, 2019 5:12 pm
Awesome! Thank you I didn't use the equal sign or single quote when I tried that. Adding those returned the result I needed.
Thanks.
Online Members
