AnsweredAssumed Answered

Doing math with dates assigned to variables

Question asked by henderson123 on Sep 9, 2018
Latest reply on Sep 10, 2018 by fmpdude


I want to do Math with the dates. Let's say to find the difference between the 24/12/2018 and then 2/1/2019. When you do this with actual numbers it is easy. However the twist is that these values are assigned to variables. This is the case because the user chooses the two dates.

So there are two variable names, Date 1 and Date 2 (both have the format dd/mm/yyyy (date data type in filemaker pro)). However when I try to subtract the two, no matter what I try filemaker thinks it is a mathematical expression. Can someone please help?

Outcomes