Crystal Reports 9.
I need assistance writing a formula where I select records where SERVICE_CALL.SERVICE_CALL_ACTION_DT is current date less 3 days (ie: 3 days ago), and print the SERVICE_CALL.SERVICE_CALL_ID.
I am having syntax issues and need perspective/help from others.
Thanks.
Group is: SERVICE_CALL.SERVICE_CALL_ID
Table is: SERVICE_CALL
Fields are: SERVICE_CALL_ID and SERVICE_CALL_ACTION_DT
I need assistance writing a formula where I select records where SERVICE_CALL.SERVICE_CALL_ACTION_DT is current date less 3 days (ie: 3 days ago), and print the SERVICE_CALL.SERVICE_CALL_ID.
I am having syntax issues and need perspective/help from others.
Thanks.
Group is: SERVICE_CALL.SERVICE_CALL_ID
Table is: SERVICE_CALL
Fields are: SERVICE_CALL_ID and SERVICE_CALL_ACTION_DT