Questions Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020

@bob-beardsley Not pretty, but what about something like this?

=Right('0'+CStr(Month([SOOrder.OrderDate])),2)+Right('0'+CStr(Day([SOOrder.OrderDate])),2)+CStr(Year([SOOrder.OrderDate]))

I have a similar need, also in a GI, except for the AMOUNT field. 

The amount field must show NO commas, but always include 2 decimal places.  When I un-format the field, it displays with 4 decimal places - Probably because of Company Config that shows pricing/amounts as 4 decimals.

But I can't seem to find the right combination to show 2 decimal places, without showing the commas.  Despite this being in a GI, I can't include a schema for the field.  here is the formula.

= IIf( [BT.DrCr] = 'C', -1*[BT.TranAmt], [BT.TranAmt] )

BT = PX.Objects.CA.CATran

the resulting AMOUNT field looks like this...

 While the commas are gone, the amounts are showing 4 decimal.  Any assistance would be helpful.

Thanks!