Date between 2 others 
Author Message
 Date between 2 others
I must know if the date contained in a field of File1 is between two is
contained in the Date1 field and Date2 of File2. This in order to be
able to put information in a portal.


Tue, 24 Sep 2002 03:00:00 GMT
 Date between 2 others

Maybe you could use a calculated field with a formula like:

If( (date1File2 < dateFile1) and (dateFile1 < date2File2)
; "It's between" ; "No it's not" )

succes,
Ronald

* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful



Tue, 24 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

2. SQL: Select some data with date criteria, but only by Date part of date field

3. Dates, Dates, & More Dates

4. DATE DATE DATE Filemaker and Month names

5. SGML->DSSSL(or others)->SQL(or others)?

6. Locking Records so others can't read

7. Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

8. passthru queries work on some servers not others

9. analyzer and others application for client tool of SQL 2000 won't work

10. Urgent: Some workstations faster than others...

11. Locking Down an individual database while leaving the others accessible

12. Can't connect to MSDE server from some machines, can from others


 
Powered by phpBB® Forum Software