I would like to find the number of days between dates in a particular column and current date.
you can use DateTimeNow() for today's date/time and DateDiff() to calculate the difference between your date and today. All the functions have help text and examples when you start inserting a calculated column.
DateDiff('day', DateTimeNow(), [Your Date])
please upload a sample dxp, it might depend on what exactly you want to do (visualization axis, calculated column...)
Appreciate your help.
I tried doing the same but I get the message " All parts of the expression have to be aggregated"
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer