topic Fisical Year Condition in App Development

Fisical Year Condition

Prabhu1204 — Thu, 05 Nov 2020 11:05:12 GMT

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 — Fri, 06 Nov 2020 01:39:49 GMT

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

Prabhu1204 — Fri, 06 Nov 2020 05:02:06 GMT

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 — Fri, 06 Nov 2020 05:24:27 GMT

Its my mistake, its MakeDate()

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

Prabhu1204 — Fri, 06 Nov 2020 05:59:22 GMT

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

MayilVahanan — Fri, 06 Nov 2020 06:03:17 GMT

You can use Year(Today()) also.

FYR: