Trying to exclude date in function

[Anonymous]

Hey BI Community, 

I may have a very simple question, but for some reason, I can not seem to find an answer to my problem. I am trying to put together a very simple formula that takes into consideration multiple columns and then outputs an expression. What I am trying to do is figure out how to list a column that will produce a "Late" text value. The formula is as follows:

Late Open = IF(PurchaseOrdersData[Line Status] = "Open", AND(PurchaseOrdersData[Projected Date] < TODAY(), PurchaseOrdersData[Projected Date] <> VALUE("1/1/1900")), "Late")

I think there are some things I am missing I am sure however the important aspect of my problem is that I can't seem to figure out how to make the highlighted section work. I NEED to make sure that the date is included in the expression but I can't seem to figure out how. 

Any help would be greatly appreciated! Thank you!

[AlB · Accepted solution]

Hi @Anonymous 

Try

Late Open =
IF (
    PurchaseOrdersData[Line Status] = "Open"
        && PurchaseOrdersData[Projected Date] < TODAY ()
        && PurchaseOrdersData[Projected Date] <> DATEVALUE ( "1/1/1900" ),
    "Late"
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

This worked perfectly thank you so very much for you help!