Create = Closed

Hi,
Have the following →


want to find when created date = closed date
Thank you.

IIF(
Format([Issue].CurrentHierarchyMember.Get(‘Created at’), ‘yyyy-MM’) =
Format([Issue].CurrentHierarchyMember.Get(‘Closed at’), ‘yyyy-MM’),
“Created = Closed”,
“Created <> Closed”
)

ey!
Almost there.
You have the DateCompare function. In which you have to compare like:
Although, maybe it is better to ensure they are Dates with the DateParse function

IIF(
	DateCompare(
		DateParse([Issue].CurrentHierarchyMember.Get('Created at')),
		DateParse([Issue].CurrentHierarchyMember.Get('Closed at'))
  ) = 0
	,
	'Created = Closed',
	'Created <> Closed'
	)
1 Like