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

String to Date formula

14 Views

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":

DateValue ({UDWARHOUSE.WELCOMELETTER})

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:

({@DateLetter}) - {HOUSEMASTER.SETTLEMENT_DATE}

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

Any thoughts on where I'm going wrong?