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 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...
I am having a problem since i upgraded to XP from win 98se. The GL keeps closing right in the middle of "merging transactions" (after posting) and i have corrupt data. I did all the above as well. Help
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 "merging transcations". After this happens we have corrupt data. I have a couple of XP...
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.