Forum Discussion
IF statement for date range
Hi there, Trying to post a list of gifts and have a dynamic card drawing from dates added. The goal is to list a range of dates added if there are more than one distinct value for date added. To...
Hi Anonymous
please try
=
IF (
HASONEVALUE ( PA_DGR_Liam[date_added] ),
FORMAT ( VALUES ( PA_DGR_Liam[date_added] ), "MM yyyy" ),
FIRSTDATE ( PA_DGR_Liam[date_added] ) & " - "
& LASTDATE ( PA_DGR_Liam[date_added] )
)