Build some basic functions around Dates that allow calculations to be done on Date Fields. Days(), Year(), Weekday(), etc
Looking to do basic date calculations like days(enddate) - days(startdate) = duration in days
We have some customers using custom plugins to accomplish this at the moment, and can help you do similar. Please email us for more information if you’re interested.
We still do have plans to add improved date calculations, but it doesn’t look like we will be able to release that until 2016.
As a potential new user wondering where this critical feature landed - looks like the thread began ~2 years ago with feature planned to be launched by end of 2015.
I am a new user, and having date calculations like those we use in Google Sheets/Excel will be necessary for us calculate ages and perform similar "date arithmetic." Hope it arrives soon. Have to say, though, it was wonderfully simple to get most of our database up and running so quickly. Really appreciate the support.
We need this feature for our Project naming convention....
[Client Code] "-" [YYMMDD] "-" [id]
Any idea on how to do that?
Yes, you should be able to handle relative dates via a plugin. However, the results may be a bit slow to return.
Would this plugin be able to filter something like:
select if “date field” > TODAYSDATE and < TODAYSDATE+7
Yes; to add a bit to the 6/30 comment...the core system will eventually be getting more powerful date calculation features but this is possible now using a plugin that you could develop or Zengine could develop for you - depending on where you want to use it and what you want to use it for.
We will not be releasing date calculations by July 31, 2015. However, we do have at least one client using a custom plugin to display custom date calculations on the record overlay sidebar. If something like that would work for you, contact us and we can get you hooked up with something similar.
Any ideas if you will release (date diff) some Date calculations by July 31st 2015 ?
This feature is not yet available. We are currently working on some very big database changes that will let us support this feature in the future. It's still on the roadmap for this year, but I don't have a specific date for release.
Ivan Bozhilov commented
Is this feature available?