Have you tried
MIN( max([your date field]),today())
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
You would do the following
if max([Date]) > Today() then Today()
You may have to use an LOD calc depending on what context you want the max date of.
Create a calculated field like below
Attached the workbook
Hope this helps kindly mark this answer as correct or helpful so that it will help others
foorum.twbx 12.9 KB
1 of 1 people found this helpful
that was real simple
Max(if Sample_Date_field<=today() then Sample_Date_field end)