We send out POs using break/routing in the report style.
We would like to use the PO data as part of the file name of the invoice – PO#-yymmdd or something similar.
However the default date format appears to be the full date: Tuesday, March 19, 2021, which is too cumbersome.
Is there any way to change the format of this field?
Thanks.
—sam
@skhayatt There are separate Month Day and Year but I don’t remember liking their format either. I would just set the value I wanted for the pdf name in a UD in POHeader and then grab that when printing.
Thanks. Will give it a shot.
If you can figure out how to do that from in the RDD I bet you could get it to work. I haven’t tried formatting in the RDD.
Did not think of that. The other thing was considering was creating a directive-level variable, but have never done that before.
As it turns out, the user is OK with that format being used as part of the file name, so I will play around for my own education when I have a moment.
Has anyone figured out a solution to this APR Email date formatting issue? It is incredibly unhelpfulf to have all dates show up in the long format.
I would also like to format a decimal amount to only include 2 decimal digits. I’ve tried playing around with the {date} format in the Report Data Definition without any luck, but I’m not really sure I’m even doing it right.
I don’t think you can do that easily. If you really, really need it, one thing you can try is add a string UD field (for POHeader or whatever) and then a BPM that populates it with the format you want (maybe PO.Update.Pre). Then, bring that in the RDD and use it in APR.
Thank you, I will give that a try.