11-16-2016 5:32 PM - edited 02-03-2024 8:18 PM
hi
I have 3 columns in a report. Date1, date2 and date3. I need a variable that will return the max date of any of these 3 columns. In other words, I should have a new column that's contains one date. Which is the max date of any of the 3 date columns.
Can anyone help?
Thanks
Will
Try this:
=if([Date1]>[Date2] and [Date1]>[Date3]) then [Date1]
elseif([Date2]>[Date3]) then [Date2]
elseif([Date3]>[Date1]) then [Date3]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.