I've been working with a Custom Function that generates a list of dates based on 2 input dates (start date and end date) as follows:
GetAsDate ( EndDate ) > GetAsDate ( StartDate );
GetAsDate ( StartDate ) & ¶ &
DateRange (GetAsDate ( StartDate ) + 1; EndDate );
GetAsDate ( StartDate )
The list of dates that is returned (in DD/MM/YYYY) format might look as follows:
I need to have the list always show the dates with leading zeros for the day and month, i.e.:
I haven't been able to work this out so far - can anybody help with the required modification to have the date range in DD/MM/YYYY with leading zeros for the DD and MM?