problem with linking dates

[#1]

Hello,

I have two data sets that I want to connect with a common 'date' field. One data set has sales numbers and the other has weather information. Basically what I'm trying to achieve is to create a date field that when selected will show me sales and weather for that selected date. I'm not sure why it isn't working for me, maybe because of date format? I attached my qvw file

Thanks

[#2]

Hi,

you can make acommon date format like ........

date(salesdate,'dd/mm/yyyyy') as date

and

date(weatherdate,'dd/mm/yyyyy') as date

similiarly u can extract month and year from these date fields

hopw that will work .....

Regards,

Dushyant

[disqr_rm · Accepted solution]

You may use DayStart() function to fix this problem. The reason is that your date field also has time associated within. Something like this should work:

date(daystart(weather.date)) as Date
date(daystart(Date1)) as Date

Hope this helps.

[#4]

Thanks for very prompt responses.

Dushyant I tried changing date format but it doesnt work me.

Rakesh's solution works for me. It seems like time was the issue.

Thanks