3954111

Resolved by using ADD_MONTHS({custom_field_name}, -12) Using a negative number subtracts months so: 12 months = 1 year 180 months = 15 years ...

Thank you very much. I did split it into two fields and it seems to be working logically. Now, I just need to make sure that I can fit it all in and it not be unmanageable. One thing I did notice that some people may not. Any field you are attempting to reference within the custom record must precede it in order. So if my…

Unfortunately if I use the WHEN for the second clause I have to use TO_DATE('datehere','MM/DD/YYY').... So this still leaves me in the same place regarding length of formula. I don't understand your reference to converting to Julian date. Any other ideas?

OK I understand what you are saying, but I am not counting the number of months I am setting a value to the field based on the specific month to month time frame. So this value does not correspond to the length of time from month to month For example: [CODE] CASE WHEN {customstartdate} BETWEEN '07/01/2012' and '08/01/2012'…

Just nothing.

Seems like it worked adding the non breaking space - cached for a while but finally just worked. However, if you have a better suggestion, please let me know. And, thanks again.

Thanks, but it would seem that I am not able to enter a value that would literally not display "Call for Price". For example, I tried adding &npsp; but that did not work.