i thought it would be something like DATETIME_FORMAT(TODAY(-30 DAYS), ‘MMMM’)
or MONTH(TODAY(-30 DAYS) Its the subtracting days part i dont understand
simple i know but im at a loss to make the stupid red letters go away
OR how can i find out what date was 30 days ago and format that? i also need this for 60 days and 90 days to populate on a notice thats printed from page designer and sent certified mail. but i am competent enough to parse those myself once someone lets me cheat off their homework for the first one.