Limiting Date

[Pomna]

Hello , I need to limit date in load script of two dimensions  [Available From Date] and  [Available To Date].  I need

[Available From Date]  to begin from current date AND 

[Available To Date] to end two years from current date. 

Below is my code which is not working. Can anyone tell me how to fix this? Thanks

IF([Available From Date] >='$(=Year(Today()))' ,[ Available From Date]) as [Current Availability],

IF([Available To Date] <='$(=Year(Today())+2' ,[ Available From Date]) as [End Availability],

[MayilVahanan]

Hi Pomna,

Try like below

IF(Year([Available From Date]) >= Year(Today()) ,[ Available From Date]) as [Current Availability],

IF(Year([Available To Date]) <=Year(Today())+2 , [ Available From Date]) as [End Availability],