Unix Time, Query criteria, and Null values

[Johnny]

Hi all,

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

=(DateDiff("s",#01/01/70#,[Enter start Date])) And <=

(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

 

[MGFoster]

Hi all,

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

=(DateDiff("s",#01/01/70#,[Enter start Date])) And <=

(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.

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.