UK CA Unified Infrastructure Management User Group

 View Only

  • 1.  Alert on approaching date

    Posted Jul 26, 2017 09:22 AM

    Hi all,

     

    Does anyone have a method of alerting on an approaching date?

     

    Here's an extract of a line from a csv file:

     

    DOMAIN\USERNAME,Web Server,13/01/2017 09:13,13/01/2019,Company Name,hostname,Location

     

    I'm looking for a way to alert me on when this date highlighted in bold is X amount of days away.

     

    This script creates the Unix timestamp, but then I'll need a way to deduct the date found in the CSV file against todays date:

     

    local time = "01/17/2017 6:50 PM"
    local month, day, year, hour, minute, am_pm = time:match("(%d+)/(%d+)/(%d+)%s+(%d+):(%d+)%s+(%w+)")

    print(month, day, year, hour, minute, am_pm)