Re: Query calc # days

[rob@xxxxxxxxx]

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.