Hi. I am trying to create a formula that will allow me to calculate how long a request has been in the system based on a certain milestone. I have the formula for the milestone and it seems to work.
My problem is that I can not figure out how to make the aged formula (see what I have below). The error i receive says that "the remaining text does not appear to be part of the formula and the date after the comma in the first row is highlighted. I have taken tried taking out the comma and then I get an error stating that says "the remaining text does not appear to be part of the formula"
HELP PLEASE!
{@Milestone} = "Aged 0 to 30 days
",
({requests.rpt_date} - 30) to CurrentDate,
IP Logged