Formula in dataset to count days between current date and date in column

Get Help
1

Hi there,

I’ve a question about a formula column in a dataset. I store a date in a column x in the dataset. In another column xibo should use a formula to determine how many days there are between the current date and the date stored in column x.

Is there anyone who can help me out? Many thanks in advance.

2

Something like:
DATEDIFF(CURDATE(), Date)

CUREDATE() returns current date

Date - in this example it is the column name with date

DATEDIFF() - it will, by default, return the difference in days as integer between the two dates provided.

3

Yes, this is doing the job! Many thanks for your quick response and solution.