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?