Convert string to Date Time
Posted on 2004-03-27
I am reading a date field 'mm/dd/yy' from a table. I need to be able to perform calculations on it to determine if it is older than 90 days. When I pull it from the table using the .AsDateTime, it comes back with the value '0'. However when I convert it to a string, it works fine and displays the date. I am assuming this is because my date is not formatted correctly including the time 'MM/DD/YY HH:MM:SS.' Is there a way I can get around this and just store and work with the date only?
verifiedDate := Form1.tblAgents.fieldbyname('EmailVerified').AsDateTime;
strVerifiedDate := DateTimeToStr(verifiedDate);