DATE_DIFF({{Temp_Date_Time_Start__c}}, {{Temp_Date_Time_End__c}}, MINUTE) as a UI-Field
When I enter the start time it calculate to “NaN”. When I enter the end time it does not recalculate.
DATE_DIFF({{Temp_Date_Time_Start__c}}, {{Temp_Date_Time_End__c}}, MINUTE) as a UI-Field
When I enter the start time it calculate to “NaN”. When I enter the end time it does not recalculate.
This formula is meant to calculate the difference between two DATE fields. It seems like your entering in DATETIME fields. You’ll need to use the following functions to get a time difference.
You for sure can get the values you want with the functions found in V2.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.