Is there a relatively simply way to count the number of days there are in this month. Last month WITHOUT hardcoding the month in. What I am going to do is take the number of days in the month, subtract the number of days already past, add the number of days left and multiply the data to do...
This one has me completely bewildered:
I need to select data by date for one month. I want the same data (but a month earlier) side by side for comparisom purposes.
I have 3 fields #cust #date #amt
So I would have
Customer Name
Oct-1-2003 25% Sep-1-2003 15%
Oct-2-2003 24%...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.