20.08.2021
00:28
Hello all,
Does anyone configured a calculated column in the reports to calculate the difference between current date and a date field from the form?
I was trying days (getdate() - form field) but it's not accepting the days formula.
Thank you!
20.08.2021
01:09
Hello Andreia,
just use this:
DATEDIFF(day, WFD_AttDateTime1, getdate())
where WFD_AttDateTime1 ist your FormField
Further infos are found here: https://docs.microsoft.com/de-de/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15
Hope this helps,
Bjoern
20.08.2021
01:47
Hello Andreia,
just use this:
DATEDIFF(day, WFD_AttDateTime1, getdate())
where WFD_AttDateTime1 ist your FormField
Further infos are found here: https://docs.microsoft.com/de-de/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15
Hope this helps,
Bjoern
Hi Bjoern,
Thank you for your input however the formula does not work on Reports.
The formulas for calculated columns are a little bit special and I think not all the expressions can be used there.
20.08.2021
01:58
Hi Bjoern,
Thank you for your input however the formula does not work on Reports.
The formulas for calculated columns are a little bit special and I think not all the expressions can be used there.
Hi,
which version of WebCon are you using (tested on 2020 version .434)?
I implemented this solution for testing in my existing report and it worked.
The screenshot shows you the german version of a new calculated column (Neue berechnete Spalte):
Did you used "text" as returning type?
WFD_AttDateTime1 has to be changed into WFD_AttDateTimeXX where XX is the actual number of your DATE form field. You can't use the clear names!
Bye,
Bjoern
P.S.: If it doesn't work, please post a screenshot of your FORMULA and your FORM FIELD DEFINITION, so we can help a little bit more...
20.08.2021
03:50
Hi,
which version of WebCon are you using (tested on 2020 version .434)?
I implemented this solution for testing in my existing report and it worked.
The screenshot shows you the german version of a new calculated column (Neue berechnete Spalte):
Did you used "text" as returning type?
WFD_AttDateTime1 has to be changed into WFD_AttDateTimeXX where XX is the actual number of your DATE form field. You can't use the clear names!
Bye,
Bjoern
P.S.: If it doesn't work, please post a screenshot of your FORMULA and your FORM FIELD DEFINITION, so we can help a little bit more...
Hi Bjoern,
The issue was with the type of field that was being returned. When I switched to Text it worked.
Thank you!
