GetAsDate()

 <  Day Day Up  >  

GetAsDate()

Category: Text

Syntax: GetAsDate ( text )

Parameters: text ”any text expression or text field that returns a date, formatted the same as the date format on the system where the file was created.

Description:

GetAsDate() interprets a text string that contains a date as an actual date. Anytime you use a date constant within a calculation formula, you should use the GetAsDate() or Date() functions to ensure that the date is interpreted correctly.

Examples:

 

 GetAsDate ("1/1/2004") 

Returns 1/1/2004 stored internally as a date.

 

 GetAsDate ("1/1/2004") + 8 

Returns 1/9/2004 . In this case, had the GetAsDate() function not been used, "1/1/2004" + 8 would have returned 112012 .

 <  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