Hi,
I would like to compare an input date and current date in a IF statement
I have no idea why the following code doesn't work properly
If Format(Itm_Date_of_Shipment, "mm/dd/yyyy") >= format(now(), "mm/dd/yyyy") then
' update the table...
else
' display error message
end if
please advise.
thanks
ALice
I would like to compare an input date and current date in a IF statement
I have no idea why the following code doesn't work properly
If Format(Itm_Date_of_Shipment, "mm/dd/yyyy") >= format(now(), "mm/dd/yyyy") then
' update the table...
else
' display error message
end if
please advise.
thanks
ALice