If ElseIf dependent on date

[PBCN]

Hi

Ive got a if statement that calls a function dependent on a date in a field, but every time i click on it, it still calls function A even though the date is less than the date in the code below.

I have used stop breaks and the date is showing up over the Me.DateApplicationReceived

Any suggestions will be really appreciated.

If Me.DateApplicationReceived = Null Then
    Call A
ElseIf Me.DateApplicationReceived >= "1/12/2019" Then
    Call A
Else: Call B


End If

[orange]

Date values should be enclosed with #, not "
eg

Me.DateApplicationReceived >= #1/12/2019#

[CJ_London]

to add to Orange's suggestion, the date needs to be the US format of mm/dd/yyyy

1/12/2019 will be interpreted as 12th January

Also, nothing can 'equal' null in vba, not even null=null, you need to use the isnull function

If isnull(Me.DateApplicationReceived) Then



edit: or you can use the nz function and simplify your code

If nz(Me.DateApplicationReceived,#1/12/2019#)  >= #1/12/2019# Then
    Call A
Else
    Call B
End If

[PBCN]

Awesome, thank you orange and ajax