Read date like 1992

Hi,

In Table I have some date in format like 18.maj.92 when I convert it by string to Date&time Node I get 2092-05-18 but it should be 1992-05-18.

But of course in datebase there are years 1950-2021 and they are in string in format dd.MMM.yy.

hi @89trunks ,
you can transform the date string using the Column Expressions node with the following expression

left(column("date_column"),7)+ 
string(
    (right(column("date_column"),2)<"22")*100 + 1900 + toInt(right(column("date_column"), 2))
)

then send the output to the String to Date&Time node and parse it as dd.MMM.yyyy

@duristef

Hey, Thank for help this is it. I have one question why somehow some date after column expressions have addition “.0”

For example date 30.dec.69 sometimes is
30.dec.1969
30.dec.1969.0

Maybe sometimes the year is evaluated as a double.This expression should solve the problem

left(column("date_column"),7)+ 
string(
    toInt((right(column("date_column"),2)<"22")*100 + 1900) + toInt(right(column("date_column"), 2))
)

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.