Hi @ChrisPals,
You can do it in a simple way,
Here are the steps :
- Check today’s date using : Now.Date
- Check whether the date is above 15 or below …
- If above 15, then date you need to enter is 15- Now.Month - Now.Year
- Else the date will be 15 -( Now.Month - 1) - Now.Year