Hi,
does anybody know how to calculate a date based on a given date?
I tried to calculate in a new column a date based on a previous column:
(date-column)-14
but it seems not to work!
Cheers
Yogie
Convert the 14 days into seconds i.e. 60*60*24*14
60 seconds *
60 minutes *
24 hours *
14 days
I think this will work.
Leo
I tried it. But nope…doesn’t work… With timefield it does (if I remember it correctly) but not on datefields.
Leo
When you use a date in a calculation, Tap Forms is substituting the Unix epoch time for the date value. The Unix epoch time is the number of seconds that have passed between January 1, 1970 until the date specified or the current date if you use $now in your formula. So if you’re subtracting two date/times for example, you’ll get the number of seconds between those two date/times. Using math you can convert those to other units. But Tap Forms won’t generate a new absolute Date or Time value for you. I know that’s something I’d like to add support for.
.
