Date format Query

[veybo]

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!

[/\/\isanThr0p]

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)

[MartinSmith]

Again somewhat confused why you are posting this here but you could check out the DatePart function.

[/\/\isanThr0p]

wow some powerful function!!!
takes a while to read the whole syntax