Hello, in a form view, I have two date type selectors, so I have a start_date and an end_date, and I’d like it to auto-complete the selected date range in a decimal type field. I haven’t found a solution, so if a kind soul could explain to me whether this is possible.
It sounds like you want the suggested value for a second date field to be calculated based on a first date field. If so, you can do this by setting the initial value for the second field set to [first-date-field]+x where x is the number of days you want the range to be.
if what you are trying to do is set the second date field based on the first date plus a value, you can use the same formula in automatic formula field where x is the value in your number field. Not sure why you use a decimal value though. An integer value would be what you would want most likely.
Are you looking for something like.. HOUR([EndDate]-[StartDate])/24?
In my virtual column of decimal type that I’ve named _time_input_date, it increases/decreases step by 0.25, because the context is that it’s working time expressed in quarters of a day.
My goal is that when a user selects a start_date and an end_date, an auto-completion is performed in this field.
I’m putting up a screenshot to illustrate what I want.
I apologize in advance, being French, but it shouldn’t be too hard to understand.
