Unix time stamp date and criteria

[madrag]

Hello,

I need help I have DB with Unix time stamp field. I was able to convert this to date format with Time: DateAdd('s',[ARRIVAL_TIME],#1/1/1970#) calculation.
However i can't find a way to put "filter" in Criteria row in query design. I would like to achieve posibility to pick start date and end date and get rows from DB between those two.



HELP PLS !!!

[June7]

I don't understand. If the query has correct date structure then the filter criteria should be the same.

BETWEEN #1/1/1970# AND #12/31/1970#

BETWEEN [enter start] AND [enter end]

[madrag]

Thx for anwser - yes i was playing with that but i'm doing something wrong seems so...
So again. I have this ARRIVAL_TIME field in DB which holds time in UNIX time stamp. In Access I'm using convert calculation as above.
What are possibilities to debug this and find out what i'm doing wrong?

[June7]

Exactly what is not working - error message, wrong results, nothing happens?

I've never had to deal with Unix time. But what I find indicates your expression should work, unless your timestamps are including hh:mm:ss. Your filter parameters do not include those units.


Here is another calc:
Format(([unixdate]+2209161600)/86400,"dd/mm/yy hh:nn:ss")

[madrag]

Thx aagain for your time.
What is not working is that after I put parameters in here - BETWEEN [enter start] AND [enter end] - my query do not return results - table is empty.
Maybe I'm putting in wrong parameters formats...?
When I'm not using any Criterias i'm getting format as here:

ARRIVALTIME
21/11/2005 14:01:26

edit:
Just made query with criterias and i get results which seems ignored somehow this...
edit 2:
seems i've meade it - was entering dates in wrong format - it has to be mm/dd/yyyy

[June7]

Glad you have a solution. You might find this of interest http://allenbrowne.com/ser-36.html