I created a table where I want to count the number of days between days.
I’m not clear as to how I’m suppose to format the date in the formula edit box.
I tried several combinations and I’m getting a funcky repetitive date.
Keeps saying December 31,1969
There are a couple of ways to do this:
option 1 use 2 date fields and specify second date on a table; first SS
option 2 if you want to compare to say today use the TODAY() function; second SS
option 3 if you really want to specify the date in the code use the NEWDATE() function; third SS
@Eddzo, the date value you passed in might look like a valid date to a human, but it’s not a valid date according to Tap Forms. So you have to tell Tap Forms how to interpret your date value before it knows what you’re talking about.
To convert 10/22/2018 into a real date value, you need to use the DATE() function.
This will tell Tap Forms how to interpret the human readable date format into an actual date value the computer can understand.