I have dates comparison field using the script below but when I load it returns no values populated on the field, it populate dashes on the field. below is the script that I have used:
YTD - LYTD
if(if(Month(date(Floor(Date)))<=3,(Year(date(Floor(Date)))-1)&'-'&(Year(date(Floor(Date)))),(Year(date(Floor(Date))))&'-'&(Year(date(Floor(Date)))+1))=if(Month(((today())))<=3,(Year(((today())))-1)&'-'&(Year(((today())))),(Year(((today()))))&'-'&(Year(((today())))+1)),1,0) as YTD_Flag,
inyeartodate(Date, $(vDateToday), -1,4)* -1 AS LastYTDFlag
