-
date's in ms access
I have a formula i use to get sales info "Month to Date".
Between CDate(DatePart("m",Date()) & "/01/03") And Date()
This works well and rolls over every month like it should. Our purchasing has a cut-off of the 25th. The 26th would be the first day of the "purchasing month". I am trying to get a query to return all po's from the 26th of last month up to today and roll over every month so the user running the query doesn't have to worry about a date range.
any help would be appreciated.
TIA
Tom
-
SELECT * from table3 where date Between CDate(DatePart("m",Date())-1 & "/26/03") and Date()
-
date's in ms access
I should have mentioned that I am getting the data from a "linked table" which is a DB2 table via ODBC. The dates, looking from access, appear to be "text" properties. I use something like this to get it as a date:
salesdateateValue(DB2AS_invoiced_yada_yada_yada)
when I try to run a more compex date formula I get a variety of problems. the las was a compile error. I am going to try to do a make table for more info than I need and see if I can narrow it that way.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|