Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

DATEADD in EU format issue

Topic Labels: Dates & Timezones
579 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasilii_Lysenko
5 - Automation Enthusiast
5 - Automation Enthusiast

I have the day of payment (PayDay value).
and that the next payment will be after 1 month.

I need formula which generates date of next payment,
In correlation based with today, I have to pay either this month or next (the formula decides)

there are some peculiarities
If the payment date of the current month has already passed, PayDayToPayDate is before today, then add a period of +1 month to the date. OK

I solved my task with US Date Format and it works well no bugs there.
But EU is bugged - it increases value of month instead of day value.
Am I making a mistake in the formula?

My code here
image

US_PayDayToPayDate

IF(PayDay,DATETIME_FORMAT(DATETIME_PARSE(MONTH(NOW()) & "/" & PayDay & "/" & YEAR(NOW()), "L"), "L"),"")

US_NextPayment

IF(US_PayDayToPayDate,IF(US_PayDayToPayDate < DATETIME_FORMAT(NOW(), "L"), DATETIME_FORMAT(DATEADD(US_PayDayToPayDate, 1, 'months'), "L"), US_PayDayToPayDate),"")

EU_PayDayToPayDate

IF(PayDay,DATETIME_FORMAT(DATETIME_PARSE(PayDay & "." & MONTH(NOW()) & "." & YEAR(NOW()), "DD.MM.YYYY"), "DD.MM.YYYY"),"")

EU_NextPayment

IF(EU_PayDayToPayDate,IF(EU_PayDayToPayDate < DATETIME_FORMAT(NOW(), "DD.MM.YYYY"), DATETIME_FORMAT(DATEADD(EU_PayDayToPayDate, 1, 'months'), "DD.MM.YYYY"), EU_PayDayToPayDate),"")

JustForTest

DATETIME_FORMAT(DATEADD(EU_PayDayToPayDate, 1, 'months'), "DD.MM.YYYY")
0 Replies 0