Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
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],