Re: Interval search

> On Wed, 7 Sep 2005 12:35:22 +0200, Remi-Noel Menegaux wrote:
>> Create 2 global date fields 'DateFrom' and 'DateTo' and put them in a
>> layout such that the user will have to enter dates. The formula becomes
>> : Interval = DateTo - DateFrom
>> Remi-Noel
>
> I'd recommend instead to use DateTo and DateFrom as global fields,
> applying the search as directly as
>
> enter find mode
> paste result (Date, DateFrom & "..." & DateTo)
> perform find
>
> - Martin

Thanks a lot for your fast help!

It worked out perfectly :-)

/Daniel


.

Relevant Pages

  • Re: Datumsdifferenz o. Samstage u. Sonntage
    ... Dim i As Long, j As Long ... Public Function countWeekDays(DateFrom As Date, DateTo As Date) As Long ... If DateFrom> DateTo Then ...
    (microsoft.public.de.access)
  • RE: Finding the amount of days between two dates.
    ... "NateBuckley" wrote: ... "Mike H" wrote: ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
    (microsoft.public.excel.programming)
  • Re: The original version
    ... One of the fundamental principles of Anchor Modeling is that it is ... based on DateFrom for the new attribute’s value. ... There is no DateTo. ... Regarding history of databases this is logical nonsense. ...
    (comp.databases.theory)
  • RE: Finding the amount of days between two dates.
    ... "NateBuckley" wrote: ... life of me I can't figure this out. ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
    (microsoft.public.excel.programming)
  • Re: Other FM discussion groups?
    ... Remi-Noel ... > Can anyone recommend some other good FM discussion groups? ... > happy with the skill and response rate of what I've seen here (so no ...
    (comp.databases.filemaker)