String to Date conversion
Hi,
I have a CSV file which has a date column with date and null, while converting the string to date using the Date.parse function getting NaN for null values. This works for the value which is da...
Forum Discussion
Are you asking how to fallback to a default value in the null case? You can use the logical-OR operator (||) for such a thing. The operator will evaluate the left-side and, if it is “falsey”, it will return the result of the right-side. For example, if you wanted to use the current time when Date.parse() returned null or NaN, you can write:
Date.parse($column) || Date.now()
Or, if you wanted to return a fixed date, do something like this:
Date.parse($column) || Date.parse("2017-01-01T00:00:00")
Thank you this worked. I used Date.parse($column) || null
