BPM Logic - Best practice to check if date field is empty?

Epicor ERP 10
1

I’ve got a BPM that sets the ProjectTask.DateComplete to today when the task is marked complete. The Project Managers sometimes set the date complete field while their filling out the form, so I added a BAQ number of rows query to see if the date field is newer than 10 years old. It works, but that seems like a very hokey way of doing it! empty.

Is there a better way?

image
image

2

you should be able to look for a Date = null… in the database, the dates are either populated with a date, or they are a null value.

3

@timshuwy - Duh! He he. That was too obvious, and worked like a charm. Maybe I should start drinking coffee in the afternoons.

image

1 Like