cancel
Showing results for 
Search instead for 
Did you mean: 

Using dates relative to today in Dataverse calculated field conditions

The options are currently rather limited when setting calculated date fields in Dataverse. There are many use cases where a field's date must be compared with today's date, or an increment thereof. 

 

The standard operators are currently available (=, >, <...) but date field values can only be compared with other date field values or an absolute value (see Type in the figure below). It would be great if there would be another "Relative" type which could allow for comparisons with a relative date (one year ago, one month ago, one week ago, today, next week, next month, next year), and the addition or subtraction of a number of days (increment). 

 

CharlesS_0-1609288048113.png

 

Status: New