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)