Minute()

 <  Day Day Up  >  

Minute()

Category: Time

Syntax: Minute ( time )

Parameters: time ”any valid time value or expression that returns a valid time value.

Description: The Minute() function returns an integer representing the number of minutes from the given time value.

Examples:

 

 Minute ("10:45:20") 

Returns 45 .

 

 Minute ("12:07 am") 

Returns 7 .

 

 Minute (Get (CurrentTime)) 

Returns a value from 0 to 59.

Comments:

The Minute() function always returns an integer in the range from 0 to 59. If you want the output of this function to always be expressed as a two-character string (for example, 07 instead of 7 when the time is 4:07 p.m.), use the following formula:

 

 Right ("00" & Minute (time) ; 2) 

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net