-
Date format Query
Just an easy one here for a guy who doesn't program in VB ever.
I've got the Date using the "Date" variable, but I need it in a different format.
Currently it displays in the format: dd/mm/yy
I would like it in the format: 2002/mm/dd
Is there a simple way of doing this? (Without text manipulation)
Please reply to [email protected] with an answer thanks.
Cheers!
-
well I would propose you something with textmanipulation but it is so simple that you wont mind:
(and also why did you post that here?)
well there is a method called split
split cuts a string in parts by a seperator so just use split with "/"
the returnvalue is an array holding the 2 parts
now you can just make the new string by adding them in the new order:
array(2)+array(1)+array(0)
-
Again somewhat confused why you are posting this here but you could check out the DatePart function.
-
wow some powerful function!!!
takes a while to read the whole syntax :)