List of acceptable formulas/calculations

[fmpanz]

Hi,

I trying to be able to calculate a date 30, 60 and 180 days prior to a given date.

for instance, the date in question is January 15, 2017 – I want to create three fields that will return 30, 60 and 180 days prior to January 15, 2017.

Also, do you have a master list of acceptable calculations and formulas to use with Tap Forms?

Thanks!

[Brendan]

This is all I’ve got right now:

Calculation Field

As for date calculations, a date is represented by the number of seconds that has elapsed since January 1, 1970 00:00:00 GMT. This is called the Unix Epoch date.

To calculate the date from a specific date 30 days prior, you need to do a little math.

Start Date – 30 * 24 * 60 * 60

For 120 days prior:

Start Date – 120 * 24 * 60 * 60

And so on.

You’ll also have to set the Result Type parameter on the Formula Editor to Date.

Hope that helps!

Brendan

[fmpanz]

Hi Brendan!

That worked perfect. Thanks for clearing that up.

Regards,
Frank

[Author]

Posts