hi All!!!!
i want to custom data format thru
formatdatetime
but it's only have fixed formats..
how i make format like this dd/mm/yy
thanks
Printable View
hi All!!!!
i want to custom data format thru
formatdatetime
but it's only have fixed formats..
how i make format like this dd/mm/yy
thanks
Create your own function using the Day(), Year() and month() functions
here's an easier one that I wrote
hope that helpsCode:datarr = split(VARdatmmddyy, "/", -1, 1)
datddmmyy = datArr(1) & "/" & datArr(0) & "/" & datArr(2)
michael