(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › A question and a Statment....
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic A question and a Statment.... (Read 348 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
A question and a Statment....
Mar 9th, 2008 at 8:53pm
Print Post Print Post  
I have a database, the tracks loans that where granted on a date and is paid back over four weeks, what I am wanting is to be able to run a report that will give me four weeks of information from a date that I ask for going back from that date, can anyone point me in the right direction, or the right sesame issue.
  
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: A question and a Statment....
Reply #1 - Mar 10th, 2008 at 4:32am
Print Post Print Post  
For info for 4 weeks earlier than a given date:
Retrieve records that are > (given date - 28) and < given date

For info for 4 weeks after a given date:
Retrieve records that are < (given date + 28) and > given date

May have to fine tune with <= or >=
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge