Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF Statement

I am trying to do an IF statement comparing a column containing dates. Basically, I want to say IF an order date is between two dates, it is labeled as year 1.   EX: If the order date is between 9...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

    If(and(Orderdate>=date(2015,9,1),Orderdate<=date(2016,8,31),2016,

    If(and(Orderdate>=date(2016,9,1),Orderdate<=date(20176,8,31),2017))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi

If(and(Orderdate>=date(2015,9,1),Orderdate<=date(2016,8,31),2016,

If(and(Orderdate>=date(2016,9,1),Orderdate<=date(20176,8,31),2017))