Error with formulas with dates involved

Hii everyone!

Is anyone else out there experiencing problems with formulas with dates involved?
I have a PWA that I have not made any modifications and I am experiencing errors in the calculations of the formulas with dates.

Please anyone with some advice. Thanks!!

I think the logic for “date math” changed Yesterday… like adding days and hours to a date/time is not calculating like it used to be.

EX: ( N / 24 ) = HOURS OF THE DAY or DATE + ( N ) add DAYS to that DATE… Where N represents a database variable.

That logic has not worked since yesterday. Someone out there experiencing this???

Please I need some assistance here, all the formulas for calculating DATES when a numeric variable from the database is involved, are miss functioning.
I’m experiencing this in all my apps. I think some logic changed a few days ago.

When you try to calculate a date event using formulas and some variables are coming from the database, Adalo is just saving “Current Day” as a result.

For EX:
Captura de pantalla 2024-09-13 091916

This basic formula of adding “days” to “Current Time”.
In the "Seguimiento " case, is working because the number is plain “7”…
BUT in the case of "Vencimiento " is NOT working, because the “plan dias” is a variable coming from the database ( and Yes, “Plan Dias” is a number restricted field, working properly a few days ago )

This same logic misses functioning in more complicated formulas all around my apps.

Has anyone noticed this in your apps?

Hmm… Seems like a bug. I’ve tested now and seems like the formulas are not working if we add db values. Even formulas that adds to number properties doesn’t works. Informing Adalo…

Adalo team is aware of this issue and working on a solution :raised_hands:

1 Like

Thanks!!

I will keep you posted if I get any news on the support ticket.
Awful bug🤦is messing up all my app event hahaha.

Seems like it’s fixed! :partying_face: Works for me now!

Yeep!! same here, no errors for now.

Thanks for your help @dilon_perera

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.