abhinandan yavagal Posted February 11, 2019 Share Posted February 11, 2019 I would like to find the number of days between dates in a particular column and current date. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 12, 2019 Share Posted February 12, 2019 Hi 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. Something like: DateDiff('day', DateTimeNow(), [Your Date]) Gaia Link to comment Share on other sites More sharing options...
abhinandan yavagal Posted February 13, 2019 Author Share Posted February 13, 2019 HI Gaia, Appreciate your help. I tried doing the same but I get the message " All parts of the expression have to be aggregated" Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 13, 2019 Share Posted February 13, 2019 please upload a sample dxp, it might depend on what exactly you want to do (visualization axis, calculated column...) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now