Thank again for your helps.
Below is one of the code and I am trying to seperate the day out. However, I failed.
LotDateForSK = DateValue(FileDateTime(PathForTime & myFileName))
The format of my calander system is 10/17/2006.
Tried to get the month out, below is the code used
Temp=Right(Left(LotDateForSK,4),2) ==>17
However, it fails when the date is 10/9/2006 but ==>/9
Anyone can help me with this?