StringToDate

NigeGriff · Post by **NigeGriff** » Thu May 28, 2009 3:53 am

I'm trying to use StringToDate and generating the followin error message :- 'Conversion error calling conversion routine date_from_string data may have been lost'.

The format is - StringToDate(trim(svTermDate2,' ','A'),"%yyyy-%mm-%dd")

svTermDate2 = svTermDateYYYYMinus1:"-":svTermDateMM:"-":svTermDateDD

svTermDateYYYYMinus1 = YearFromDate(TimestampToDate(T1_Input.TERM_END_DATE)) -1

svTermDateMonth = MonthFromDate(TimestampToDate(T1_Input.TERM_END_DATE))

svTermDateDay= MonthDayFromDate (TimestampToDate (T1_Input.TERM_END_DATE))

svTermDateMM = str('0',2 - len(svTermDateMonth)):svTermDateMonth

svTermdateDD = str('0',2 - len(svTermDateDay)):svTermDateDay

I'm using the str function to add leading 0's to the month and day values output from the MonthFromDate and MonthDayFromDate functions.

When i view the value contained in svTermDate2 as part of an output dataset it looks OK even though the warning message is generated.

arvind_ds · Post by **arvind_ds** » Thu May 28, 2009 3:57 am

What is the format of your input date.?

NigeGriff · Post by **NigeGriff** » Thu May 28, 2009 4:36 am

The input date is TermEndDate and is a timestamp format.

chulett · Post by **chulett** » Thu May 28, 2009 7:26 am

Specifically... YYYY-MM-DD HH24:MI:SS? All fields other than year always two digits? You can't do StringToDate() from a full Timestamp, you need to pass it just the date portion.

NigeGriff · Post by **NigeGriff** » Thu May 28, 2009 11:02 am

I am already converting the term_end_date into a date format using TimestampToDate before applying any of the other functions.

chulett · Post by **chulett** » Thu May 28, 2009 11:15 am

Just going by what you posted as your first example:

The format is - StringToDate(trim(svTermDate2,' ','A'),"%yyyy-%mm-%dd")

Kryt0n · Post by **Kryt0n** » Thu May 28, 2009 6:05 pm

How many rows are you sending through and how many warning messages are you getting? Refine your input until you can work out which record is giving the warning.

Then send all your stage variables to an output stream (concatenate within quotes or brackets so you can see the full string of each). If issue still not obvious, post your source and stage variable values here.