1 of 1 people found this helpful
Something like you described should work.
When you say "two different files merged into one" do you mean that you are using data blending or that the source has already been merged and is a single file?
Are you stuck on an error, or is it just not working the way you expect?
If you are trying to match on the month and year, you'll want a calculation like:
Month (Date) = Month (Campaign End Date)
Year (Date) = Year (Campaign End Date)
Thanks for the prompt reply.
The data source is already merged into one and it is being pulled in as a single table.
Also, what I meant to compare was the dates are in this format - 12/31/2012. I want to compare the months and if the Months match, then Present that data
I tried to create 3 Calculated fields , the first two the converts the Date to Strings and then basically Compare those two strings to the month level.
mid([Conerting Date to a string],3,4) = mid([Converting Date to a String2],3,4)
This is what I used. But I did not get the correct result.
Do you think I can go for a different format to compare the dates and use that filter to present data?
Guess that you can use the datetrunc-function on both of your date-attributes in order to compare the dates and set the filter.
Please see the calculation "Filter" in the attached workbook.
Hope this helps you forward