[vbnewbiee]

Hi folks,

I am a new joiner on this forum and have a very simple question - hoping someone can help me.

I want to save datetimepicker value of date and time in two separate text files. Currently, when I select a date from datetimepicker and save it in a text file it saves both date and time as below:

5/11/2011 8:25:06 PM

What I would like to happen is as below:

Datefile.txt saves 5/11/2011
Timefile.txt saves 8:25:06 PM

Alternative solution that can work for me would be, if the time (only the TIME) can be modified after saving as below:

saved datetime into text file is 5/11/2011 8:25:06 PM

How can I modify the time only to say 12:00:00 PM.

By doing so I would like to keep time as 12:00:00 but date can be changed by the user using the datetime picker.

Any ideas? Thanks in advance friends..

[BobRodes]

investigate the left and mid functions.

[thava]

use the format function

[BobRodes]

Well, that might be a better solution too.