Convert Time to Text

[JRWPD]

I have a field that is set as date type Date/Time with the format set as Short Time. I have it set this way because I need to use military time.
Unfortunately I also need to export the date to another Access Data base that needs to see the time as text instead of Date/time but still needs to be shown as military time. IE: 11:30 PM needs to be seen as 23:30.

How would I convert the data.

JR

 

[SteveR77]

JR,

You could apply the following format command to your time field.

Format(#11:30 PM#,"hh:mm&quot
Returns ===> 23:30


Instead of the hard code time you would need to have your time field.

Format([MyTime],"hh:mm&quot

HTH,


Steve

 

[JRWPD]

I guess maybe I don't understand. I already have the records, can I convert them to text and how ?
Please be simple because my expression understanding is simple.

JR