I have an IF THEN formula on a Crystal 9 form to put together multiple fields. (for PeopleSoft Financials, on an Oracle 10g database)
I'm trying to get a date to display in the DD/MM/YYYY format, but I cannot seem to find the correct solution...
If I just have + ToText({APY2021.PAY_DOC_DT})
within the formula, it prints like
Tuesday, 30 September, 2008
If I have + ToText({APY2021.PAY_DOC_DT}, 'DD/MM/YYYY' )
then is prints like
DD/09/YYYY
What did I use in this formula so that this date piece prints properly in the DD/MM/YYYY format?