1 of 1 people found this helpful
Hi Parimal Pandey,
I'm glad I can help you with this!
As you said, a datetime field in the primary data source will not blend with a date field in the secondary data source.
A datetime field may be converted to a date field using a calculation to remove the time portion.
Select Analysis > Create Calculated Field, and in the Formula text box, type the following formula:
Blend the data sources on the new date fields that are created.
Here is my source, credits to this KB articles we created: Issues with Blending on Date Fields | Tableau Software
Any issue, make sure to type in the Search box first // Knowledge Base
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!