Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Why doesn't this work?
=sum({$<DateShouldBeSend={'<=$(=Max(SelectedDates))'},DateItHasBeenSend={'>=$(=Min(SelectedDates))'} >} hours)
table1
order number
DateShouldBeSend
DateItHasBeenSend
hours
table2
week
year
SelectedDates
there is no connection between table 1 and table 2.
Hi,
Check whether all the date dimensions are in the same date format. That may be the problem.
Regards,
Jagan.
Oh it seems DateShouldBeSend and DateItHasBeenSend where not the same date format.
needed to do Date(DateShouldBeSend,'DD-MM-YYYY') as DateShouldBeSend,
You may try this small change in syntax:
=sum({$<DateShouldBeSend={"<=$(='Max(SelectedDates)')"},DateItHasBeenSend={">=$(='Min(SelectedDates)')"} >} hours)
Regards,
Murali
Hi,
Check whether all the date dimensions are in the same date format. That may be the problem.
Regards,
Jagan.