I want to create a column which will store the difference between 2 dates which are in string format. Knowing dateDiff function would work, however, my dates are in string format and dateDiff wont take string as arguments.(screenshot 1) Example-
Expected Resultant Column Diff= 1 (which is D1-D2).
Note- We simple want to know, how many days the file arrived late than the expected date.
And I would like to see the result as a difference of the below 2 strings. Is there any approach, as dateDiff/difference function is not working because of the following error(screenshot 2) .
Could anyone please provide a calculation to find the difference.