calculate the 25th day of every month based on the current date

Question

I have to calculate the 25th day of every month based on the current date, with the following requirements:

If the current date is on or after the 25th day of the month, then return the 25th day of the current month.
If the current date is before the 25th day of the month, then return the 25th day of the previous month.

I am looking for an expression that dynamically calculates and returns the date, ensuring it always falls on the 25th day based on the current date.

So I have to get the 25th of every month based on current date in the From date calendar control.
Trying to achieve it through expressions.

Please let me know if you ahve any other approach for it.

sfrancoisdt · Answer

Hi Nagma_NkIn my example I have used a calendar control as this made testing easier, for your purpose just substitute the calendar control for the current dateI have broken the problem into 3 steps.Calculate the 25th of this monthCalculate the 25th of last monthDecide which one is appropriateBelow are the detailed steps.1.Calculate25th ofthis month We calculate the start of this month using the Start Of Month function.Then Add 24 days to get to the 25th day of the month using the Add Days functionWhen working with expressions I find it easiest to build them from the outer most function inwards.Start with Add Days25th of this month Step 1Then drag Start of Month into first the input field25th of this month Step 2Lastly drag the date into the input for the Start of Month function (substitute current date for your solution).25th of this month Final Step2. Calculate the 25th day of last Month (read this one a couple of times if you need to)With the functions we have available my calculations are broken down below.Start of this month (Calendar) - 1 Day = End of Last MonthStart of Month (End of Last Month) = Start of Last MonthStart of Last Month + 24Days = 25th day of Last MonthI used Add Days and passed in -1, but this can be replaced by Subtract Days instead.Taking the same outer most to Inner most approach as before.Add 24 days25th of Last Month step 1Calculate the Start of Last Month25th Day of Last Month Step 2By subtracting 1 day25th Day of Last Month Step 3From the Start of This Month25 Day of Last Month Step 3Substitute Current Date for your solution25th Day of Last Month Final Step3 Decide which date to useNow base on the current date choose which value to use using logical operatorsDecide which date is the correct oneBelow are the ExpressionsAll the expressionsBelow are tests showing the expressions working.Date < 25th​​​​Date >= 25th​​​​​I hope this helps