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]))

amitchandak's avatar
amitchandak
Super User
5 years ago

@Matpel10 , Test as

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