Code: Select all
If IsNotNull(ORCL.ORDER_DATE) and svOrderDate<>'' and StringToDate(svOrderDate,"%yyyy%mm%dd") < '2010-03-01'
Then
'ABC'
Else 'DEF'
Copy_of_Transformer_77,0: Conversion error calling conversion routine date_from_string data may have been lost
Code: Select all
If IsNotNull(ORCL.ORDER_DATE) and StringToDate(svOrderDate,"%yyyy%mm%dd") < '2004-03-01' and svOrderDate<>''
Then
'ABC'
Else 'DEF
Copy_of_Transformer_77,0: Conversion error calling conversion routine date_from_string data may have been lost
Copy_of_Transformer_77,0: Failure during execution of operator logic.
Please help me understand the same if statement with same conditions but in different sequence produces warning or failure.