Exporting a time column

[michelle]

I am attempting to export a time in the format "hhmm".
The column is defined as date/time so after I run the query
and export the results it always exports the date as well
as the time. I just need the time in a string format
of "hhmm" not in any date/time format.

 

[Lynn Trapp]

Try this:

Format([YourDateField],"hhnn")

 

[Michelle]

That works to display the time in the query results but
when I export those results it exports the entire
date/time not just the "hhmm" as I need.

-----Original Message-----
Try this:

Format([YourDateField],"hhnn")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am attempting to export a time in the format "hhmm".
The column is defined as date/time so after I run the query
and export the results it always exports the date as well
as the time. I just need the time in a string format
of "hhmm" not in any date/time format.

.

 

[Lynn Trapp]

How about converting it to a string first:

CStr(Format([YourDateField],"hhnn"))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

That works to display the time in the query results but
when I export those results it exports the entire
date/time not just the "hhmm" as I need.

-----Original Message-----
Try this:

Format([YourDateField],"hhnn")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am attempting to export a time in the format "hhmm".
The column is defined as date/time so after I run the query
and export the results it always exports the date as well
as the time. I just need the time in a string format
of "hhmm" not in any date/time format.

.

 

[Michelle]

Perfect, thank you.

-----Original Message-----
How about converting it to a string first:

CStr(Format([YourDateField],"hhnn"))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

That works to display the time in the query results but
when I export those results it exports the entire
date/time not just the "hhmm" as I need.

-----Original Message-----
Try this:

Format([YourDateField],"hhnn")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



I am attempting to export a time in the format "hhmm".
The column is defined as date/time so after I run the query
and export the results it always exports the date as well
as the time. I just need the time in a string format
of "hhmm" not in any date/time format.



.

.

 

[Lynn Trapp]

You're welcome

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Perfect, thank you.

-----Original Message-----
How about converting it to a string first:

CStr(Format([YourDateField],"hhnn"))

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

That works to display the time in the query results but
when I export those results it exports the entire
date/time not just the "hhmm" as I need.



-----Original Message-----
Try this:

Format([YourDateField],"hhnn")

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



I am attempting to export a time in the format "hhmm".
The column is defined as date/time so after I run the
query
and export the results it always exports the date as
well
as the time. I just need the time in a string format
of "hhmm" not in any date/time format.



.

.