Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

If Statements with Between Dates multi conditions

Hello,

I would like to write a formula in a column that says:

IF(Open_Date, between 2021-01-01 and 2020-07-31 then 0%,

IF(Open_Date, between 2022-08-01 and 2022-12-31 then 2% * 1,
IF(Open_Date, between 2023-01-01 and 2023-31-12 then 3% * 1

 

Would anyone be able to assist me please?

Thanks,
D

  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous I would try something like this:

    Column = 
  SWITCH(TRUE(),
    [Open_Date] >= DATE(2020,7,31) && [Open Date] <= DATE(2021,1,1),0,
    [Open_Date] >= DATE(2022,8,1) && [Open Date] <= DATE(2022,12,31),.02*1,
    [Open_Date] >= DATE(2023,1,1) && [Open Date] <= DATE(2023,12,31),.03*1
  )

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous I would try something like this:

    Column = 
  SWITCH(TRUE(),
    [Open_Date] >= DATE(2020,7,31) && [Open Date] <= DATE(2021,1,1),0,
    [Open_Date] >= DATE(2022,8,1) && [Open Date] <= DATE(2022,12,31),.02*1,
    [Open_Date] >= DATE(2023,1,1) && [Open Date] <= DATE(2023,12,31),.03*1
  )