Fisical Year Condition

[Prabhu1204]

Hello All

i am developing a app and I ma  using the below condition

IF(SALEDATE>DATE(2020,4,1),"Yes","No").. next year the year should be 2021. the date and month should be the same

How to use variables for this

[MayilVahanan]

Hi @Prabhu1204 

IF(SALEDATE>DATE(Year(Today(1)),4,1),"Yes","No")
- It will gives 2020 now, next year, it will give 2021.

[Prabhu1204]

I tried and it shows error in expression. Am i doing anything wrong 

=IF([PAB/PRB Date]>DATE(Year(Today(1)),4,1),'Yes','No')

[MayilVahanan · Accepted solution]

HI @Prabhu1204 

Its my mistake, its MakeDate() 

=IF([PAB/PRB Date]>MakeDATE(Year(Today(1)),4,1),'Yes','No')

[Prabhu1204]

@MayilVahanan Thanks a ton .. Is it necessary to give Year(today(1) or it can be year(today())

[MayilVahanan]

Hi @Prabhu1204 

You can use Year(Today()) also. 

FYR:

https://community.qlik.com/t5/QlikView-App-Development/Today-v-Now/td-p/191765

https://community.qlik.com/t5/Qlik-Design-Blog/The-Now-amp-Today-Functions/ba-p/1518108#:~:text=Now(....