Use excel file do Subtract dates is not work

i want to do H2=F2-G2
but error


Well it’s kinda normal what happens , because we are converting everything to strings when the user uses the text builder. Now in order to fix your issue you would need to open the advanced editor and write something like :
CurrentRow.ByField(“Column1”).DateTimeValue.Subtract( CurrentRow.ByField(“Column2”).DateTimeValue).Days

and that would generate the desired output

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.