Calculate Date Field

[RachelBedi]

Hello again folks,



I'm trying to write some code to add on business days for a follow up.

In the after update of my field I have;

If [Date Modified] = (Weekday(Date) = 1) And [Status] = "submitted" Then
[ActivatorFollowUpDate].Value = [Date Modified] + 3
End If
If [Date Modified] = (Weekday(Date) = 2) And [Status] = "submitted" Then
[ActivatorFollowUpDate].Value = [Date Modified] + 3
End If

so on and so on - the intention is to find the day of the week and add on 3 business days so if it's Friday it will add 5 to the Date Modified and fill that date into ActivatorFollowUpDate

I'm sure my syntax is totally wrong I just am not sure where to go next

[June7]

Do you also need to account for holidays?

Don't see anything wrong with that syntax. Have you tested it. Are you getting errors?

[RachelBedi]

No need to account for holidays at this time

I have tested it and it does nothing - meaning the field does not update it remains null I also get no errors

[June7]

Form is bound to table and the ActivatorFollowUpDate field is in the form RecordSource? Have you step-debugged? Review link at bottom of my post for guidance on debugging techniques.