# Error with formulas with dates involved **URL:** \ **Category:** Get Help\ **Created:** [September 12, 2024, 1:06am UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703 "2024-09-12T01:06:40Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![nvrjulian](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nvrjulian/32/23002_2.png) [@nvrjulian](https://forum.adalo.com/u/nvrjulian)\ **Post date:** [September 12, 2024, 1:06am UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/1 "2024-09-12T01:06:40Z")
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!! ---
**Author:** ![nvrjulian](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nvrjulian/32/23002_2.png) [@nvrjulian](https://forum.adalo.com/u/nvrjulian)\ **Post date:** [September 12, 2024, 3:08pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/2 "2024-09-12T15:08:59Z")
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??? ---
**Author:** ![nvrjulian](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nvrjulian/32/23002_2.png) [@nvrjulian](https://forum.adalo.com/u/nvrjulian)\ **Post date:** [September 13, 2024, 12:26pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/3 "2024-09-13T12:26:23Z")
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](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/d/3d549a5cc6c327ed277cd8af47ea07e2639708fd.png) 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? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [September 13, 2024, 5:29pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/4 "2024-09-13T17:29:02Z")
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… ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [September 13, 2024, 5:37pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/5 "2024-09-13T17:37:10Z")
Adalo team is aware of this issue and working on a solution 🙌 ---
**Author:** ![nvrjulian](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nvrjulian/32/23002_2.png) [@nvrjulian](https://forum.adalo.com/u/nvrjulian)\ **Post date:** [September 13, 2024, 7:43pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/6 "2024-09-13T19:43:07Z")
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. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [September 18, 2024, 9:43am UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/7 "2024-09-18T09:43:17Z")
Seems like it’s fixed! 🥳 Works for me now! ---
**Author:** ![nvrjulian](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nvrjulian/32/23002_2.png) [@nvrjulian](https://forum.adalo.com/u/nvrjulian)\ **Post date:** [September 18, 2024, 1:14pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/8 "2024-09-18T13:14:10Z")
Yeep!! same here, no errors for now. Thanks for your help @Dilon ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [September 28, 2024, 1:14pm UTC](https://forum.adalo.com/t/error-with-formulas-with-dates-involved/49703/9 "2024-09-28T13:14:51Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.