Confirmed jobs

[ianmuir]

I run a script on exiting my database. It checks a field "provisional_booked" for a date and then checks "job_Confirmed"

If "job_confirmed" is empty and "provisional_booked" has a date it puts up a custom dialog box saying "There are jobs for tomorrow which are not confirmed. Would you like to see them?"

it inserts the current date + 1 into a date field so it can check the next days jobs.

My boss wants it to, on a Friday check Mondays jobs. any ideas?

I have attached script steps.

[comment]

Try:

Let (

today = Get (CurrentDate)

;

today + 1 + Position ( "76" ; DayOfWeek ( today ) ; 1 ; 1 )

)

[ianmuir]

Thanks I will

[ianmuir]

Fantastic! is there a way on a Friday it can check sat and monday jobs?

Thanks!!