Search results for query: *

It is formatted as: FormatDateYYYYMMDD(GlobalFields.Item("MCURYEAR"),GlobalFields.Item("MCURMONTH"),GlobalFields.Item("MCURDAY")) Below is the above vaules MCURYEAR - Year(Date()) MCURMONTH - Month(Date()) MCURDAY - Day(Date())

I spoke to soon... It works if the dates land correctly: Ex (works fine) {*FormatedCurrentDate} = 20090529 {*FormatedCurrentDate-5} = 20090524 Ex that doesnt work Ex {*FormatedCurrentDate} = 20090601 {*FormatedCurrentDate-5} = 20090596 <--(96 instead of 24) Any way to get around this?

mirtheil, you pointed me in the right direction. I look at "{*FormatedCurrentDate}" and copied it, minus 5 in the new one and it worked great. Thank you

sorry, didn't work. This works BUT no idea how to get the minus 5 in there: AND OEINVH.INVDATE BETWEEN {*FormatedCurrentDate} AND {*FormatedCurrentDate} I tried {*FormatedCurrentDate} -5

Per 9.6 I want the last 5 days in a query. I have the following and it works: OEINVH.INVDATE BETWEEN 20090525 AND 20090529 I also have used this for current date only and it works: OEINVH.INVDATE >= {*FormatedCurrentDate} Now I want BETWEEN current date AND current date minus 5 How can I...

Thanks, it worked so that makes you DA MAN - Happy Holidays and Thanks for the x-mas gift - :)

Thanks for the info but i am a little lost - :( Let's say my user name is bob & password is larry - How would your above command be entered? I tried it but it desn't seem to work. I am running: php 4.3.2 mysql 4.1.7 Apache 2.0.52 Just a side note, i conect connect with user name ODBC

I installed MYSql/PHP/Apache on my Windows 2003 server. I created my database, added users and granted FULL perrmissions to all my uses but when i go to connect i get: There seems to be a problem with the MySQL server, sorry for the inconvenience. So I start the MYSql server by the command...

Thank you for all your help. I edited the files+250, only time will time. Thanks again

I don't understand you question. After it closes, when we try to reenter, we can't get pass the corupt data error message.

I am having a problem since i upgraded to XP from win 98se. The GL keeps closing right in the middle of &quot;merging transactions&quot; (after posting) and i have corrupt data. I did all the above as well. Help

I am having the same problem. What did you do to fix it. Thanks in advance

I upgraded from Win 98se to XP pro. We are running plus dos 6.5. I change the files=250 in config. When posting in the General Ledger, the Accpac program closes without notice in the middle of &quot;merging transcations&quot;. After this happens we have corrupt data. I have a couple of XP...

I entered &quot;Files=250&quot; in config.nt. It didn't work. Any more ideas people. Thank you