I'm trying to determine whether a file exists with a name that includes the current date. The File Existence Monitor seems like the tool to use for this, but I find that if I use date variables in the name, they don't seem to be expressed when I test. For example, I have a file at: C:\Sandbox\file_exists\myfile_11-12-2013.txt
If I use "\\${IP}\c$\Sandbox\file_exists\myfile_${DD}-${MM}-${Year}.txt" as my File Path in the File Existence Monitor, the resulting error is "File '\\192.168.21.23\c$\Sandbox\file_exists\myfile_${DD}-${MM}-${Year}.txt' not found.", but if I use "\\192.168.21.23\c$\Sandbox\file_exists\myfile_11-12-2013.txt" as the file path, it is found successfully.
Am I going about this the right way?