By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

How to show weekly monthly data in a report.

P: n/a
Hello everyone,

I need your help with a query.

Currently I display the data in a daily format. I have a form that the
users submits the date range (from say 20061224 to 20070530) and the
data is displayed daily.

I like to know how I can show the data in weekly and monthly way.so
that for the range shown above I would have the monthly or weekly
only.

Unfortunatly the date format in the db has the type text and is stored
as yyyymmdd.

i.e table.

date, sales, product and I can show daily only.

Please show an example where I can show this data in weekly and
monthly format.

Thank you all.

May 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
az****@gmail.com wrote:
Hello everyone,

I need your help with a query.

Currently I display the data in a daily format. I have a form that the
users submits the date range (from say 20061224 to 20070530) and the
data is displayed daily.

I like to know how I can show the data in weekly and monthly way.so
that for the range shown above I would have the monthly or weekly
only.

Unfortunatly the date format in the db has the type text and is stored
as yyyymmdd.

i.e table.

date, sales, product and I can show daily only.

Please show an example where I can show this data in weekly and
monthly format.

Thank you all.
Hi,

To say the obvious: You now know why you should store dates in dateformat
and not as text. ;-)

Anyway: It should be reasonable easy to transform your text-field to a real
datefield.

What database are you using?

And: are you looking for a real solution (= change the databasestructure),
or do you just want a hack to use the textfield in a GROUP BY approach?

And: Do you know SQL good enough to write such queries yourself? (Using
GROUP BY)

Regards,
Erwin Moller
May 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.