Need help with access expression - HELP!!

M

MelBSegue

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
 

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

Similar Threads

Excel Help with dates 2
Conditional formatting with formula (multiple criteria) 1
Record Row Color Access 07 4
sum columns between certain dates 1
Running Total 10
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Display graphical check for completed tasks 1
Create a macro to create excel line graph with coloured pointers anddata lables 1

Top