I understand my question title may be a little vague so let me explain.
I need to check to see if an object has gone past a certain date. Now here's what makes it complicated. When the object is added to the model it's only done so with a string date not actually formatted as a date. It's coming from CSV so it's the only way I can do this.
It will always be formatted as M-DD-YY.
Now, what I need to check for is to see if a reset has happened. Resets occur every Wednesday at 4am CEST. So when I'm looking at the model I can have it set as two things.
Expired objects (from the previous reset)
Current objects (that will not reset until next Wednesday)
I really can't figure out the best way to tackle this and I am open to ideas and suggestions.
Thank you.