Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If function -> Else part doesn't work

Hi,   I have data from my divisions that I collect quarterly  that are based on our Fiscal Year (starting in April) FY Quarter Number of... Number of... Number of... Number of... Number o...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    @Matpel10 , Test as

    Set date : date(Year([date])-1, month([date]),day([date]))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you! It does work. However, it is weird that it doesn't work with an IF statement. amitchandak