Skip to Content
Former Member
Nov 06, 2007 at 10:15 PM

String to Date formula


Post Author: llcoolt

CA Forum: Formula

Hey all!

I have a string field "UDWARHOUSE.WELCOMELETTER" that is used for dates. In order to bring it into my report with a date I used this formula, called "DateLetter":


Works fine until I want to determine the number of days between the string field "UDWARHOUSE.WELCOMELETTER" and a date field "HOUSEMASTER.SETTLEMENT_DATE".

I wrote this formula to accomplish the task:


It seems to work fine and returns the day expected until I refresh the report.

Any thoughts on where I'm going wrong?