Using the NPDSELECT() Function in a Custom Report

The following expressions are examples of how to use the NPDSELECT() function to extract the last 8 days of notepad stamps, as well as a specific date, using the expression builder:

NPDSELECT(contact1.notepad,(DATE()-8),' ')
NPDSELECT(contact1.notepad,'03/12/98',' ')

Please refer to TeleMagic's online help for more detailed information on the use of the NPDSELECT() function.

Note: When using this function in a Custom Report of version 3.5, a "Syntax Error" will occur. However, it still possible to save and utilize this function. The Synax Error occurs in this situation due to how a user defined function is being called that is not native to Foxprow. In version 4.x, an error of similar type will also occur. Again, the same principle is applied and the function works the same way.

 

-- End of FAQ #506

FAQ ID #506

Product Related: TeleMagic 3.5x

Last Updated:
March 20, 2000