How to get the attribute of a directory?

[VitaminB6]

In my macro, I need to get the attribute of a directory, for example, I need to have the date of a directory. Can someone help me with this? Thank you.

 

[Scott Huish]

Perhaps, something like this:

Sub test()
MsgBox DateValue(FileDateTime("C:\test"))
End Sub

 

[VitaminB6]

Hi HotPepper,

Thank you very much for your reply. This is realy want I am looking for. But, I have another question:
There are several sub-folders in a directory and I would like to run the sub-folders by time. What I mean is to run the sub-folder which time/date is earlier than the others.

In your example, it only shows date but not time. To get the time, TimeValue function can be used. However, is there a function which can get time + date?

Perhaps, something like this:

Sub test()
MsgBox DateValue(FileDateTime("C:\test"))
End Sub

 

[Scott Huish]

Sub test() 
MsgBox FileDateTime("C:\test")
End Sub

 

[VitaminB6]

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?

 

[Scott Huish]

How about:

Temp = Day(FileDateTime("C:\test"))

 

[VitaminB6]

Thank you for your great helps.