T
Tony Hewitt
Hi all,
I'm hoping that someone out there has tried this before and succeeded, or
that someone will be able to tell me it just can't be done!!!
I'm trying to retreive data from a Sage Line 100 Database, using specific
date criteria. For example:
I am trying to retrieve all Sales Orders that were raised during this June
last year. At the moment I'm using dates entered during run-time. But this
is messy and untidy.
The same function would also be used to retrieve orders during the past 12
months(rolling) and for the same time in the previous year (from July 2002
back 12 months!)
My biggest problem, is that it's preferable if the system can do this
automatically, without user intervention. But I'm struggling!
Help!!!!
Thanks in advance
Tony Hewitt
I'm hoping that someone out there has tried this before and succeeded, or
that someone will be able to tell me it just can't be done!!!
I'm trying to retreive data from a Sage Line 100 Database, using specific
date criteria. For example:
I am trying to retrieve all Sales Orders that were raised during this June
last year. At the moment I'm using dates entered during run-time. But this
is messy and untidy.
The same function would also be used to retrieve orders during the past 12
months(rolling) and for the same time in the previous year (from July 2002
back 12 months!)
My biggest problem, is that it's preferable if the system can do this
automatically, without user intervention. But I'm struggling!
Help!!!!
Thanks in advance
Tony Hewitt