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'
)