Need help with access expression - HELP!!


Joined
Jul 17, 2019
Messages
1
Reaction score
0
Status: IIf([PromiseShipDate]>=Date(),"PAST DUE",Format([PromiseShipDate],"mmm yyyy"))

The results are:
Status column shows
Feb 2019
if the PromiseShipDate is 2019-02-28

Want the results to show:
Status column
PAST DUE
if the PromiseShipDate is 2019-02-28

If I change the code to <=Date()
The entire Status column shows PAST DUE
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top