Date Difference

[ranjith]

 I have a data set with 2 date fields (Format: 2019-02-11 03:39:10)

My aim is to take the difference between the dates (in days) and store it in a separate column. 

I've tried using the date difference formula but it doesn't seem to work. 

[ranjith · Accepted solution]

This is now resolved, I had to parse the date before computing the difference in days!

[ATsao]

Glad to hear that you were able to resolve it yourself! You indeed will want to make sure that your dates are parsed appropriately before using these columns in a prepare recipe for date or time operations.