Monthname for Yesterday's Date?

[stewm]

I have a caculated field that is calcuated the day and year fine for day(add_days(today(),-1)) and year(add_days(today(),-1)) are fine. However, monthname(add_days(today(),-1) doesn't appear to want to accept it. Has anyone ever had an issue returning the name of the month of yesterday's date?

Mark

Consultants Club Corp.

 

[nagrajm]

Mark...You are missing the closing bracket at the end of the monthname function calculation.

 

[stewm]

Thanks, Nagrajm, no that's just a result of my typing during the post. What I did was added a today - 1 to my view to get out of having to do the calculation in Impromptu in a few different places. I just inserted the new item from the folder in place of the calc and it's working much better now.

Mark

Consultants Club Corp.