Re: Query calc # days

[gcrane@xxxxxxxxxxxxxxx]

actually stored in file as CMMDDYY.....I guess we missed that one on Year 
2K. 


Gail Crane
Johanson Manufacturing Corp.
phone 973-334-2676
gcrane@xxxxxxxxxxxxxxx




rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/27/2003 04:08 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Query calc # days



Hey sweetie, are the dates date fields, numeric or what?  And what format
are they in?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin


  
                      gcrane@xxxxxxxxxxxxx   
                      om                          To: 
midrange-l@xxxxxxxxxxxx  
                      Sent by:                    cc:     
                      midrange-l-bounces@x        Fax to:      
                      idrange.com                 Subject:  Query calc # 
days 
  
  
                      02/27/2003 03:36 PM   
                      Please respond to   
                      Midrange Systems   
                      Technical Discussion   
  
  




OK, you all know I am not technical.  My programmer is on vacation.  I
need to do a compare of date1 to date2 and calculate the number of days
between.  Can I do that in a query?  If yes, any direction of how would be
greatly appreciated.

Gail Crane
Johanson Manufacturing Corp.
phone 973-334-2676
gcrane@xxxxxxxxxxxxxxx
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.






_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.