Code: Select all
Oconv(Iconv(inLink.TheColumn, "D"), "D-YMD[4,2,2]")
You will always be in strife if they're sending you mm/dd/yyyy and dd/mm/yyyy in the same column.
Moderators: chulett, rschirm, roy
Code: Select all
Oconv(Iconv(inLink.TheColumn, "D"), "D-YMD[4,2,2]")
That column only has the following unique values:DateConversionBASIC..XFM: At row 23617, link "OUT", while processing column "TLTMD2"
Value treated as NULL
Attempt to convert String value "2282-01-18" to Date type unsuccessful
Code: Select all
DateConversionBASIC..XFM: At row 59250, link "OUT", while processing column "TLTMD2"
Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful
Code: Select all
IF IN.TLTMD2 <> 0 THEN Iconv(Char(IN.TLTMD2), "D") ELSE @NULL
Code: Select all
IF Status(Iconv(Char(IN.TLTMD2), "D")) = 0 THEN Iconv(Char(IN.TLTMD2), "D") ELSE IF Status(Iconv(Char(IN.TLTMD2), "DYMD")) = 0 THEN Iconv(Char(IN.TLTMD2), "DYMD") ELSE @NULL
Code: Select all
If IN.TLTMD2 Matches "7N" Then Iconv(IN.TLTMD2,"DYJ") Else If IN.TLTMD2 Matches "8N" Then Iconv(IN.TLTMD2,"DYMD") Else @NULL