>Wow. Can't believe the date command slipped my mind. Thanks Naomi.

No problem. In the meantime I realized that your variable may be of character type and wanted to update my reply with VAL() function. I hope you figured this out already.

Also the code would work only in the scope of the procedure. If you're working with the form and your variable is not global, then use Sergey's solution with a macro.