since vb dates depend on how the system date is formated
this is no good for me

how can i make sure that the date will ALWAYS be same format

"dd/mm/yyyy"
with leading 0's

such that its 07/25/2001

this has to work for no matter WHAT the system date format is like
some pick short, some pick long
some reverse the month and day, ect
i need

DAY FIRST, MONTH, YEAR (with leading zeros)

hope you guyz undrestand

format(now, "dd/mm/yyyy") doesnt work for all cases of formating the system date manually do a different one