Convert the format of a date

[omaggi]

Hi everyone.
I have a textbox with a date in the format dd.mm.yyyy hh:nn:ss (ex. 17.12.2009 09:45:00).
I want in another textbox that this date will be formatted like yyyy/mm/dd hh:nn:ss (ex. 2009/12/17 09:45:00).
How can I do?
I tried with some function (date, datepart,...) but I have not reach the right solution.

Can you help me?

Thanks and big greetings.

 

[namliam]

Is it actually a DATE/TIME field?? In that case you can simply add a new format to the control.

If it is a string, look into the left/right/mid functions, a combination of these will save your day.

 

[ChrisO]

You could also try: -

yyyy\/mm\/dd hh\:nn\:ss

As the format.

 

[omaggi]

Thanks to all you.
I found the solution. Thanks.

Greetings