Currently, calculate properties cannot add to or subtract when one of the values is a date property. It would be great if this would be possible. For example, if property A is a date property with 01/01/2023 as the date, I want the calculate property to add 12 months and give me the result of 01/01/2024.
Calculate properties also allow you to divide a number (currency property) by a duration property (calculate property). When testing the formula in the create property dialogue, it looks like it works. However, in reality, it does not. If you look at the property in a record, it will always return a value that is between 0 and 1. This needs to be fixed.
I’m not sure if this really an answer to your feature request, but calculated properties are much richer in recent versions than they used to be. For example, you can constrain the output type to be of different types now - and yes, you can add a fixed number to a date to get an offset date. See screenshot.
This does answer my question when it comes to adding/subtracting fixed numbers from dates. Thank you! Would you mind explaining what the different numbers stand for in the equation - (24*3600*1000*365)?
I appreciate your response and it clarifies my understanding of manipulating dates with fixed numbers. Thank you Could you provide more insight into the specific values represented by the numbers in the equation (2436001000*365) I am eager to understand the components better.
