Unix Time, Query criteria, and Null values

Unix Time, Query criteria, and Null values

Post by Johnn » Fri, 09 Apr 2004 22:50:19


Hi all,

I have a query that pulls from a remote Informix table
using the expression:

(DateDiff("s",#01/01/70#,[Enter End Date]))

This allows me to convert the Unix time (#of seconds from
01/01/70 to now) and get the user to enter the date in a
recognisable format.

The problem arises when I need to pull all records should
the user input be blank.

Can anyone shed some light?

Many thanks in advance,

Johnny
 
 
 

Unix Time, Query criteria, and Null values

Post by MGFoste » Sat, 10 Apr 2004 02:29:17


I replied to a post on this subject on this ng. The subject of the msg
was: "Parameter query on two fields." There you will find a solution
to your problem.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)