pwFormatDate not working

I was writing a very simple report that I am trying to format the Sage 300 date for and I get an error.  Does anyone know how to fix this or a different more reliable way to format Sage300 date fields.

I tried using:

pwFormatDate ({CPEMPL.HIREDATE})

the error I get is

"There is an error in this format.   Do you want to save it anyway?"

I can open one of Sage's default reports - for example the deposit slip and I see that they have the deposit date field with the same format and it works

pwFormatDate ({BKTRANH.TRANSDATE})

I find hits that the u21capw.dll file is missing - but where would I get this from and where would it be placed.  I am running Crystal Reports 11

Parents Reply Children
  • 0 in reply to ValerieH
    The challenge is that Crystal, for some reason, can't see where the Crystal files are installed and it is actually looking to the wrong place. The easy way to fix this issue is to put the file that you mentioned (and a few more) where Crystal can find them. On the server under c:\windows there should by a crystal sub-folder. If you copy the contents of the crystal sub-folder to your system32 or syswow64 folder (if you have c:\windows\syswow64, copy them there, otherwise c:\windows\system32). Then Crystal will be able to find the functions that your report requires.