Allow Text within a Formula

Allow Text within a Formula

Hi,

I would like to be able to use this for others things like taking an existing Date Field and copying its value, so by entering getDay(Date)&"-"&getMonth(Date)&"-"&getYear(Date) it results in 01-02-2026.

And then when the Date is changed so is this field, this can then be used to pad Sub-Forms where the Date is in the Main Form, so the export has the date in every row.

And it could be used for many other things then too, like taking other values and reformating them.

Thanks

Dan