This message was deleted.

this sounds dumb, but are you over complicating it? if one is a date field and the other is an integer, can you just add the integer value to the date and have the system do the rest behind the scenes? I feel like NS does that and I've been able to just add to dates before, but maybe i'm missing something.

Head is spinning from multiple custom calculations. I got it working using To_Date instead of Char