date fields

[#1]

I have two date fields AdmDT and StartDt.

Can I display only the dates that match?

=If(AdmDate = StartDt)

[sunny_talwar]

May be create a flag in the script

If(AdmDate = StartDt, 1, 0) as MatchFlag

and then use the flag in your set analysis

Sum({<MatchFlag = {1}>}Measure)

[#3]

Hi Robert,

Solution 1:

While do the data modelling we need to set a field based on the match.

The we can display based on the field.

Solution 2:

You can delete the unmatched records from the temp table and load the remaining data.

Regards,

Rajesh R. S.