MS access and Epoch Time format

[sirsquishy]

Hi,

We have a SQL server running collecting data from our PBX. and i am using MS access to better read the data for our day to day user.

as of now, i pretty much have things the way i want them, except the time format. in the time feields it shows up as 20050305134596

2005(Year) 03 (Month) 05 (Day) 1345 ( military time) 96 (seconds).

i need it to show up as MM/DD/YYYY Standard Non military time.

also, how can i filter a search in MSaccess by date/time.

say i want to only veiw stats for records from march 3rd till the 8th from 8am till 10pm?

thanks in advance.

 

[PHV]

2005(Year) 03 (Month) 05 (Day) 1345 ( military time) 96 (seconds)
Really ?
If the last 2 digits are valid seconds (00 .. 59) you may try this:
CDate(Format([Time field], "0000-00-00 00:00:00"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244