[CLOSED] Report with Days Difference between today and form field

0

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.

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!