MFG/PRO Progress Where Clause Criteria syntax

[KarinvanRhee]

Hi all

i am trying to do a data dump from MFG/PRO via the PROGRESS/ADMIN/EXPORT text file tool.
There is option for a WHERE-CLAUSE and BY-CLAUSE in order to select specific data from the database file.

I cannot seem to get the syntax right. I used the progress programming syntax but it gives an error.
What am I doing wrong ?
any suggestions?

Thanks so much for any suggestions.

 

[KarinvanRhee]

Never mind after some trial and error I found it , so i will close the threat already.

 

[Stefan]

Constant date values are always a bit of a nuisance. Generally they always need to be MDY even if your session date-format is DMY. Safest to use the date function which prevents any ambiguity:

where idm_mod_date >= date( 3, 31, 2023 ) // date function is always m,d,y