Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jan 04, 2021 01:53 PM
I have a product the changes cost frequently and I want to track this cost change in one field. This original formula has been working for me but now I am trying to figure out how to calculate the cost between two dates.
For example:
IF({Date},
IF(IS_BEFORE({Date},
DATETIME_PARSE( ‘1/1/2020’,’’)),
VALUE({Product}) * 0.62))
+
IF({Date},
IF(IS_AFTER({Date},
DATETIME_PARSE(‘12/31/2019’,’’)),
VALUE({Product}) * 0.53))
+
IF({Date},
IF(IS_BEFORE({Date},
DATETIME_PARSE(‘1/1/2021’,’’)),
VALUE({Product}) * 0.53))
+
IF({Date},
IF(IS_AFTER({Date},
DATETIME_PARSE(‘12/31/2020’,’’)),
VALUE({Product}) * 0.48))
Jan 07, 2021 09:46 AM
bumping this post :slightly_smiling_face: