Days between now and a dataset record

Get Help
1

hi,
i have tried to figure this out with no luck, i have a dataset with a colume (col1) with date in and colume (col2) with text.
my section should contain rows where days between now/today and the date(s) in col1. ive tried getting Datediff() to work no luck, also timestampdiff with no luck.

br
Henrik

2

Could you give me an example of your data and what should be displayed please?

3

Col1, Type = Date, Type= Value
Col2, Type = String, Type= Value

Col1,Col2
2017-01-16,Region1
2016-12-03,Region2
2016-11-29,Region3
2017-02-09,Region4

Then i need to calculate how many days between now and date in Col1