|
Best of Support |
|
|
Extracting day and month from a date |
|
Issue
I am trying to extract the day and month in the DateToWords format.
Solution
You could use the following in order to build the day and month from your date field so that it is displayed in the same manner as the DateToWords task:
%[^x=FormatDate(AnnualsMain.Financial.FinancialYearEnd, 'd')]
%[Right(NumberToRanking(x), 2)] day of %[FormatDate(AnnualsMain.Financial.FinancialYearEnd,"mmmm")]
Elizabeth Keyter