Date + Number - Why does this not work in Adalo

[jmb2021]

Hi,

I am trying to organize a few screen on adalo for subscriptions.

My problem:

User can pay a month or a year: But why does this not work - User has a property Subscription expiry date… And i am using Todays Date +365 (days) to add to the expiry field. It does not add anything to the field.

I would have assumed you could set a date field using this method,

do any of you have anyway of doing this or are any of you encountering the same problem?

I would love some solutions from the adalo community.

Best

Jordan

[njimmy10]

Hello, Try using instead of current time > use 1 year from now would be better

[charleshope]

Maybe this post will help:

Using Time/Duration in custom formulas

Adalo calculates dates using UNIX timestamps which traditionally are the number of seconds since UNIX was implemented back in 1970. The only difference is that Adalo handles these in days, meaning that if a typical UNIX timestamp is 1634310307 (number of seconds), the day equivalent in Adalo is basically just a moved decimal point: 16343.10307. Knowing this you can create records in a collection called “Duration” that have the duration in this format and then add the selected duration from a dr…

[jmb2021]

Thanks, this worked for me, somehow i did not think of this! i have been using it in other places in the app lol.

[jmb2021]

Thanks that is a helpful post for anyone out there,

best

[njimmy10]

Glad it did