Unix Time, Query criteria, and Null values

  • Thread starter Thread starter Johnny
  • Start date Start date
J

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 <=
Click to expand...
(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
 
Johnny said:
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 <=
Click to expand...

(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.
Click to expand...

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.
 
Back
Top