Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.