Jobs created yesterday (unless it's Sunday or Monday)

[gsmithmme]

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??

 

[MCuthill]

gsmithmme,

I do not have the ability to test this solution for exact syntax, but the following should provide what you seek.

{@BookDate}

IF DayOfWeek(CurrentDate)=2 THEN
(
    CurrentDate-3
) ELSE
(
    CurrentDate-1
)

Notes:
-- DayOfWeek() returns a numeric value for the day of week. Unless explicitly defined, Sunday=1, Monday=2, etc.
-- I have placed "CurrentDate" in place of "Today" in your code. You can continue to use "Today" if that works, I just have not seen that syntax.

Hope this helps! Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[gsmithmme]

Mike! Thank you so much. Works a treat!