Week of year returns a 5-8 digit number

[Vtomsons]

Hi, I have linked email data to a calendar so I can see how many messages were sent in an given week. My calendar was built using the ultimate calendar and then I linked the sent date with the calendar and tried to count how many email addresses were sent in a given week. Its returning a 5-8 digit number.

My email data was originally in DD/MM/YYY and I changed it to MM/DD/YY using Local English-United kingdom. I'm not sure why this is happening as other times I have linked ot this data from other sources it has returned the proper week #.

Any suggestions?

Val

[mahoneypat · Accepted solution]

Make sure the Date columns on both side of the relationship are Date type (not DateTime).  If DateTime, you'll need to make it Date type in the query (not just in Data View).

Pat

[themistoklis]

@Vtomsons 

When you say email data.. do you mean you use a connector which connects to an email database.

What is the source of your email data and what is the format of the date in the email dataset?