Calc Previous YTD values

[FABIS]

I am trying to create a starting point to calc the current YTD totals verses the previous YTD totals. I have tried using the 'Today', 'Curdate' and 'Now' function, but cannot strip off the year or Month from these functions. When I use [year(Curdate())] I get the following: "The function curdate is not available as an external, database or built-in function". Is there another way to come up with the system current month and year without a Prompt?

 

[nagrajm]

I do not know about the Curdate() function but year(Now()) and month(Now()) should strip away the year and month. This always works.