Can someone please tell me how to do the following:
[pymt request date] field is populated with date info in the following format: "4/06/20 3:26:43 PM"
I'm creating an "IF" stmt to be used in a macro as follows: IF [Forms]![fPRList]![pymt request date]=Date()
and i'm hoping to return the records that have the date 4/06/20 (regardless of what time is stated afterwards)
Do i need to do something else with this statement to just reference the Date and not the time portion ?
thanks in advance,