ACCPAC View Dates 1

[dmeyer54]

Hi,

I am using the ACCPAC xAPI via Visual Basic 6.

I am using the "Browse" method of a view and trying to filter based on date.

Does anyone know what format I need to put the date in my filter statement into for ACCPAC to recognize it?

I have tried the following formats:

DATEINV >= "01/01/2004"

DATEINV >= 01/01/2004

DATEINV >= "1/1/2004"

DATEINV >= 1/1/2004

Any help would be appreciated!

(We are using ACCPAC 5.1A Enterprise Edition)

 

[jayconverse]

Use YYYYMMDD, it's a number, not a date

Jay Converse
IT Director
Systemlink, Inc.

 

[dmeyer54]

Thanks jayconverse!

I wish is wasn't so hard to find the answer to something so simple!