Icon

Convert Excel Dates

Sample Datamismatched date formatsincluding Excel valuesSplit between Excel Values (upper)and DateTime strings (lower)Convert to UnixTimestampConvert to DateTimeActually, we'reconverting to LONG datatyperather than INTbecause ofsize of numbersSupply sequenceto rejoin inorder laterBring rows back togetherPut back in original orderTidy UpChange Invoice Dateto numeric type(Double)so we can use it in Math FormulaStraight conversionto Date&TimeTable Creator Row Splitter Math Formula UNIX Timestampto Date&Time Double To Int Counter Generation Concatenate Sorter Column Filter String To Number String to Date&Time Sample Datamismatched date formatsincluding Excel valuesSplit between Excel Values (upper)and DateTime strings (lower)Convert to UnixTimestampConvert to DateTimeActually, we'reconverting to LONG datatyperather than INTbecause ofsize of numbersSupply sequenceto rejoin inorder laterBring rows back togetherPut back in original orderTidy UpChange Invoice Dateto numeric type(Double)so we can use it in Math FormulaStraight conversionto Date&TimeTable Creator Row Splitter Math Formula UNIX Timestampto Date&Time Double To Int Counter Generation Concatenate Sorter Column Filter String To Number String to Date&Time

Nodes

Extensions

Links