How to calculate this in FileMaker:

% calculate moon's age in days

IP }:|= normalize( ( JD - 2451550.1 ) / 29.530588853 )

AG := IP*29.53

What is substitute calculation for [color:red]NORMALIZE in FileMaker ?

:qwery: Ino

what does normalize do (perform the calculation)

and

What does JD stand for Julien Date (current date?)

It's hard to say what "normalize" means without the context (surely there's a definition in the source code?).

Since I have done a similar calculation here, I am guessing it would be Mod().

Like to calculate some info about Moon.

Info find on the web (see att. file).

I don’t now for which computer language is written, but I like to put calculation in fileMaker format.

Ino

Moon.zip

The definition of the normalize function is given in your file:

% normalize values to range 0...1

function normalize( v  real ) : real

    v := v - floor( v ) 

    if v < 0 then

        v := v + 1

    end if

    return v

end function

So you could use this:

Let(v1=v-floor(v);case(v1<0;v1+1;v1))

Edited November 7, 200619 yr by Guest
Needed code tags to prevent garbled text

Or simply Mod ( v ; 1 ).

BTW, in Filemaker, v - Floor ( v ) cannot be negative.