Logo
  • Portfolio
  • Blog
  • About
  • Resources
Get in touch!
Show days left until deadline and if task is overdue

Show days left until deadline and if task is overdue

Type
Date

Show days left until deadline and if task is overdue

Example result for March 27, 2025

image
Logo

Portfolio

Blog

Resources

About

Contact

Notion Status

© 2025 Hyphen Productivity

YouTubeLinkedInWhatsAppPinterest
ifs(
    empty(prop("Date")),
    "Add due date".style("gray"),
    
    prop("Status") == "Done",
    "✅ Finished".style("green"),
    
    dateBetween(prop("Date"), now(), "days") < 0,
    "⚠️ Overdue by ".style("red") + 
        abs(dateBetween(prop("Date"), now(), "days")).style("red") + 
        " days".style("red"),
    
    dateBetween(prop("Date"), now(), "days") == 0,
    if(
        date(prop("Date")) == date(now()), 
        "✨ In time: Due Today".style("yellow,b"), 
        "⏱️ In time: Due Tomorrow".style("blue,b")
    ),
    
    dateBetween(prop("Date"), now(), "days") > 0,
    "🕜 In time: ".style("blue") + 
        abs(dateBetween(prop("Date"), now(), "days")+1).style("blue", "b") + 
        " days left".style("blue"),
    
    "Add due date"
)