I’m new to Fibery and something I find very limiting is lack of ability to manipulate dates. For example, suppose I have a database named “Tests” where I store some activities that have different periodicity. If I want to add a button to postpone undone tests to next period, calculate new date base…

Month(x) function was released today [image] January 9, 2025 / partying_face Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas Changelog First release in 2025 brings yo…

Adding x weeks is pretty easy: NewDate = OldDate + Days(7 * x) (pseudo code) Adding months is a bit trickier, but it’s not impossible. However, some trickiness is unavoidable, given you need to determine what the desired behaviour is in the corner cases, like 29th Feb as you mentioned. For exam…

Thank you for your always superfast reply. I agree that some operations can be obtained and “x weeks” would be just a shortcut of Days(x). But if you have an entity that have a “Periodicity” field and need to deal with all periodicities in one single formula to assign the new value lots of IFs are n…

There’s potentially even more to consider than just what should happen if there are fewer days in the following month. Like what should happen with repeated increments: March 31st + 1 month → April 30th April 30th + 1 month → May 30th ? or should it ‘rebound’ back to May 31st, given that it is con…

add the current months number of days - the difference between the current day of month and next months max number of days [image] Fibery | Start for free, upgrade when you love it Create Fibery account. Build your company workspace with no code. its still 4…

Nice one @James Wonder how it would scale if you want to add X months (not just add one)?

Thank you @Chr1sG and @James for your replies. Sorry for my late reply but I was very busy these days. In the end I used a date range field that implicitly defines the periodicity of the test/task. So I removed any other fields about periodicity and leaved only one field. The “Postpone” button ca…

[DONE] More manipulation data functions

Ideas & Features

mdubakov January 9, 2025, 3:32pm 8

Month(x) function was released today

Topic		Replies	Views
[DONE] Months() and Years() function in formula Ideas & Features formulas	5	156	January 9, 2025
[DONE] Add a number of months to a date Misc	7	568	January 9, 2025
Calculate next renewal date Get Help	8	596	July 21, 2023
Auto update a month with a daterange Misc	6	594	May 1, 2023
Set duration for month automatically Get Help	5	283	April 6, 2023

[DONE] More manipulation data functions

Related topics