@duncan_pearsonFor the cases I have, only Today() function will be relevant, for my use cases NOW() is not needed. Not sure in what (planning) use cases we need to have NOW()
能够获得当前日期或日期时间is critical functionality in any project and most use cases. I may not be speaking for the entirety of the community, but Im guessing a sizable percentage of the modelers care less about the how and more about the function. With performance considerations (of course) any viable method to pull the current date and/or date time would be a drastic improvement over what is available today and something that allows us to get this information directly from the system without additional build means we're focused on delivering results as opposed to spending time and effort to produce this data.
- testing a date as a cutoff to cumulate amounts up to a specific date. We can sometimes have data with forward due dates that calculations are required to exclude.
An option would be to allow in a now() function to allow a frequency update (dayly, hourly...) parameter to be passed as a parameter to allow action to recalculate at a defined frequency ?