I am using Crystal 8.5 with a paradox database. We have a field that stores the date a record is created. So, I have created a report that select all records where the job was created yesterday.
{@BookDate} = (Today)-1
However the user came back and said they cannot run that report on Monday, because the office is closed and so no jobs are created on Sunday. So I need to change up my formula so that if today is Monday, it will not look at jobs created on Sunday(there are none), but on Friday. Any ideas for a formula??
{@BookDate} = (Today)-1
However the user came back and said they cannot run that report on Monday, because the office is closed and so no jobs are created on Sunday. So I need to change up my formula so that if today is Monday, it will not look at jobs created on Sunday(there are none), but on Friday. Any ideas for a formula??