Does anyone know of a way to format a date in report designer as follows:
10th October 2022
I can get the date, month and year correct, but not the ‘th’.
Is this possible?
Does anyone know of a way to format a date in report designer as follows:
10th October 2022
I can get the date, month and year correct, but not the ‘th’.
Is this possible?
Best answer by lauraj46
Hi
I don’t know if there’s a standard date code for that but you could do it with a formula in the Value expression for the field, something like this:
=CStr(Day(Today())) + CStr(iif(Day(Today()) in (1, 21, 31), 'st', iif(Day(Today()) in (2, 22), 'nd', iif(Day(Today()) in (3, 23), 'rd', 'th')))) + ' ' + MonthName(Today()) + ' ' + CStr(Year(Today()))
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.