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