Set planned event in runtime

Set planned event in runtime

Good morning everybody!!!
They're days I'm on this problem, and I got only partial solutions, incompatible among each other...:(
In my project, I desire to let the user set a certain point in the timeline (date and time), and when the system time reach that point, a function is execute.
This set needs to be in the runtime...
It seems a simple issue but I could not get any solution for that.
I've been facing many problems trying to reach the solution:
  • I'm able to get the system time in a variable, but this variable type is string and I'm not able to convert it in a date_and_time type
  • When I ask the user to enter the timestamp, the UI let the user enter it as integer (cannot leave this for customers), I need something to let the customer chose a date and a time.
  • I create a VBA script that checks if a date_and_time type variable is bigger that another of the same type and if the check is positive, set a bit in a bool variable(it works), but I cannot manage to compare a variable (date_and_time) with the system time (string)

    • I'm still thinking that there will be an easy solution for this, but I cannot see it...
    Please help!
    Thanks in advice to everybody...

    This is a migrated post! Originally posted on 17.07.2014 by user marco.azzoni. Please be aware that information can be outdated.