My system date format is yyyy/mm/dd. I tried to retrieve the values of day, month and year using the simple function like this:

dim d, m, y

d = day(Date)
m = month(Date)
y = year(Date)

but it returns an error when I run it.
is it because the Date format is not dd/mm/yyyy but yyyy/mm/dd?
if thats the case, are there any other ways for me to do that?

thanks