How do I extract the AM/PM from a time date stamp?

#1 (**permalink**) 28-Jul-2006, 08:11 AM

I am able to extract the date in individual format and the time in the
individual format but I can not extract the AM/PM from this string. How do I
extract that part? I have tried using a and A for the AM/PM but that did not
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10307-how-do-i-extract-am-pm.html
work. Can anyone assist me with this issue?

*

#2 (**permalink**) 28-Jul-2006, 08:11 AM

K,
As long as that field contains Time info, a format of something like...
hh:nn a/p would give 10:00 a
hh:nn AM/PM would yield 10:00 AM
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307
Check Format/Date and Time in Help.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307

"k" wrote in message
news:3A32C68A-555B-4C99-90BB-5977ACB15FC0@microsoft.com...
>I am able to extract the date in individual format and the time in the
> individual format but I can not extract the AM/PM from this string. How do I
> extract that part? I have tried using a and A for the AM/PM but that did not
> work. Can anyone assist me with this issue?

#3 (**permalink**) 28-Jul-2006, 08:11 AM

The type of data that I am using looks like this: 4/3/2006 8

36 AM
I am working in a query pulling the different info in seperate fields to for
different fields like this: 4/3/2006
8

36 AM
The Am does not follow regardless of what I type in to try and extract it
from the data. The help sections talks about the basic format but these
tables were created prior to my employment and the format did not work. Do
you know of anything else that might work?

"Al Camp" wrote:

> K,
> As long as that field contains Time info, a format of something like...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307
> hh:nn a/p would give 10:00 a
> hh:nn AM/PM would yield 10:00 AM
> Check Format/Date and Time in Help.
>
> --
> hth
> Al Camp
> Candia Computer Consulting - Candia NH
> http://home.comcast.net/~cccsolutions
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307
>
> "k" wrote in message
> news:3A32C68A-555B-4C99-90BB-5977ACB15FC0@microsoft.com...
> >I am able to extract the date in individual format and the time in the
> > individual format but I can not extract the AM/PM from this string. How do I
> > extract that part? I have tried using a and A for the AM/PM but that did not
> > work. Can anyone assist me with this issue?
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:12 AM

K,

The AM/PM isn't part of the data, but is a result of formatting the
time for display purposes, which the query does automatically.

If you just want the AM or PM, try the following:

Right(Format(,"Medium Time"),2)

Replace by your field name.

This will format the date as a string ending in AM or PM, and then take
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307
the last 2 characters.

You might be able to get away with just:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10307

Right(,2)

Jerry