Date conversion warning

[bollinenik]

Hi,
I am trying to ocnvert 6 digit value like 'yymmdd' value into actual date format like 'yyyy-mm-dd', I am able to do it by using below function but it's throowing below warning, Can anyone help me to stop that warning.

function : StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"%yy%mm%dd")

Warning: GLTxn_tfm_1,1: Conversion error calling conversion routine date_from_string data may have been lost
How to avoid this warning.
Thanks in advance.

[f.hq]

hi,
using StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"2000%yy%mm%dd") works. But, the warning appears if the field has some invalid value. Example: "AA1253".

[ArndW]

Actually, it should be

Code: Select all

StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"20%yy%mm%dd") 

for dates in 2000 and the conversion without the century values uses the default system setttings.

If you have invalid non-date values, then you should add a call to the function IsValid() to determine whether or not you have a valid date before converting it.

[f.hq]

Actually, it should be

Code: Select all

StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"20%yy%mm%dd") 

for dates in 2000 and the conversion without the century values uses the default system ...

hi,
anybody khows how to avoid or treat the warning when the field has some invalid value using StringToDate?

The function isValid doesn't works because the input field are yymmdd and the default project value are yyyymmdd.

When I include StringToDate, it's works, but with warnings on the invalid field values.

thanks

[kpsita]

I had similar issues. So I first created a stage variable with the input date field to know if it is a valid entry or not. For eg if my input is 01-01-2001, then I created a stage variable with if else condition substring(1,2) = '-', substring(4,5) = '-' .

[kpsita]

In your case for yyyymmdd, you can create a stage variable with following condition. substring(1,4) is between 0001-9999, substring(5,2) is between 01-12 and substring(7,2) is between 01-31.

hope this helps

[Kryt0n]

The function isValid doesn't works because the input field are yymmdd and the default project value are yyyymmdd.

Then insert a "20" on the front and push it through IsValid...

[vivekgadwal]

Actually, it should be

Code: Select all

StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"20%yy%mm%dd") 

for dates in 2000 and the conversion without the century values uses the default system ...

hi,
anybody khows how to avoid or treat the warning when the field has some invalid value using StringToDate?

The function isValid doesn't works because the input field are yymmdd and the default project value are yyyymmdd.

When I include StringToDate, it's works, but with warnings on the invalid field values.

thanks

Can't you just check whether the input string is numeric first and then pass it into the IsValid() function?

Code: Select all

stagevariable1 = Num(<Field>)

stagevariable2 = If stagevariable1 Then IsValid(...) Else <Reject>

Let us know if this approach works!

[f.hq]

Hi,

thanks all.

My Isvalid function are:

Isvalid("date","20":link.field[1,2]:"-":link.field[3,2]:"-":link.field[5,2])


[]'s