Code Not Identifying Yesterday As Delinquent

[jkelly228]

Hello All,

The purpose of the below code is to identify if a shipment is delinquent or not. The intent of the code is to look at specific date and if that date is in the past then the shipment is delinquent. If that date is in the future it says whether it is next month or the month after, etc.

However, I have run into a snag. It seems to only be looking at the month. I need it to look at the day so that I know a date of yesterday is delinquent if it hasn't shipped.

Please Login or Register  to view this content.

Any help with this code is greatly appreciated.

The original posting that helped me with this can be found here

Thank you.

Kelly

[jkelly228]

Hello All,

Bumping this back up. I need for the code to not only look at current month, but current date to see if it has past.

Any help is greatly appreciated. Thanks

Kelly

[DonkeyOte]

The original suggestion satisfied the original criteria I believe.

It seems you're now saying that the revised criteria is such that :

• "Past Due": any Date Prior to Today
  
• "Current Month": any Date between Today and end of Current Month
  
• Remaining output as before

If the above is indeed the case I would say that given the variance in units of comparison it would be simplest to add a pre-emptive IF to handle prior dates

Please Login or Register  to view this content.

[jkelly228]

Hi DonkeyOte,

You were correct in your understanding. I am testing now but it looks like your code worked very well. Thank you.

Kelly