Elapsed Days from "hard coded" date

[Chuck Brennaman]

I would like to add a calculated field which shows the elapsed days from a specific or hard coded date and a date field in record.

I know I can do this by adding a field to each record with that specific date but I would like to avoid that.

I’ve tried putting the date in the calculation like ( [date field]
– Jan 1, 2012) / 60 / 60 / 24

I’ve also tried a ‘mm/dd/yyyy’ format.

Any suggestions on how to do this?

[Brendan]

Hi Chuck,

Tap Forms stores dates in Unix epoch time. Which means it’s the number of seconds elapsed from January 1, 1970 until now. Dates before that would be a negative number of seconds.

So you would have to know the number of seconds since then to put into your formula. Either that or just use a Date field in the formula.

[Chuck Brennaman]

Brendan,

Thanks for your quick response.

I had actually thought of that but was hopeful there would be an easier way.

I created a test form where I put in my date and then added a calculated field to show the corresponding epoch time. (It was 994525200)

[Author]

Posts