Sander
2021-01-26 20:53:40
Option 1
Clean up the source data. I cannot image that Excel stores proper date values with a trailing . or /.
Option 2
How are you fetching the Excel values? Does your third party (?) solution offer a method like myCell.getDateValue() that returns a date type instead of a string type?
Option 3
You could apply a simple substr() with length=8 to trim of any trailing characters. The line of code below works for me.
date d = str2Date(subStr('01.01.2020.', 1, 8), 123);
热门帖子
热门github
6
Option 3 helped out. thanks