Beginner question - Add date condition to a formula

Question

HiI'm looking to create a new field or to modify an existent one.As of 2022, this formula was okay but in 2023, the value for H sould now be 45.94 instead of 39.27 .Because we don't want it to have an impact on our reports and on our Page Designer, we need to add a condition that if the event took place in 2022, H = 39.27 and if the event took place after december 31th 2022, H= 45.94. Could someone help me? I've been trying different things but it seems that I always forget something. Thanks a lot !

Ron_Daniel · Accepted Answer

The H Value field has a simple formula that grabs the year from the date, and then assigns the value. The formula is:

IF(YEAR({Date})<=2022, 39.27, 45.94)
Note that if the Date field is empty, it will still return a value of 45.94. You could nest the formula inside of another IF statement to show nothing if the Date field is empty:

IF((Date), IF(YEAR({Date})<=2022, 39.27, 45.94), "")

Wow, thank you so much!! It worked 😊

alexandrachap · Answer

The H Value field has a simple formula that grabs the year from the date, and then assigns the value. The formula is:

IF(YEAR({Date})<=2022, 39.27, 45.94)
Note that if the Date field is empty, it will still return a value of 45.94. You could nest the formula inside of another IF statement to show nothing if the Date field is empty:

IF((Date), IF(YEAR({Date})<=2022, 39.27, 45.94), "")

Wow, thank you so much!! It worked 😊

Beginner question - Add date condition to a formula

1 Attachments

3 replies

1 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded