Calculation: Static value

[lupas]

Hi Brendan

First off, I love your App! It is just awesome!
I was thrilled how perfect the import from Bento works in 2.0, good job!
(Although I had to use “Import Form Template…” instead of “Import Bento Template…” to import my Bento database… that’s the way it should be? ;) )

I have a question regarding calculations:

I want to use a static date in a calculation field, for example:

Static Date: 01.01.1950
Variable Date: XX.XX.XXXX -> from the Field [VarDate]

Now I want to calculate the difference (in years) between those dates:

([VarDate]-(01.01.1950))/(60*60*24*365.25)

This does not work.. I tried it with
(01.01.1950)
[01.01.1950]
… and lots of other date formats..

What is the right format to use a static date in calculations?
Or is this not supported yet?

Thanks!

Greetings, lupas

[Brendan]

Hi Lupas,

The Import Form Template function is for importing Tap Forms templates, not Bento templates. Are you using Tap Forms in English? I’m wondering if maybe I have the menu command set wrong in a different language version of the menu.

Static dates in formulas is not supported. But you could just add a Date field to your form and just never change it to get the same effect. Other than that you’d have to enter in the static date in standard Unix epoch date format. Unix epoch date format is the number of seconds between January 1, 1970 and now.

Thanks!

Brendan

[lupas]

Thanks Brendan

Yes, I am using Bento in English…

Static Dates:
Perfect, works perfectly fine with the Epoch Format -631152000 instead of 01.01.1950.
For everyone else: You can calculate Dates to Epoch Format here:
http://www.epochconverter.com/

Thanks for the help!

Pascal

[Author]

Posts