Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsDate function |
|
|
| GetAsDate function |
| Format |
GetAsDate(text) |
| Parameter |
| text - any text expression or text field containing text in the same format as the date on the system where the file was created. |
| Data type returned |
| date |
| Description |
| Returns dates in text as data type date, for use in formulas involving dates or date functions. The format of text date must be the same as the date format on the system where the file was created. |
| Use the GetAsDate or Date function to enter a date constant into a formula. |
| Note If the function returns a number instead of a date, go to the Specify Calculation dialog box and make sure the Calculation result is date. |
| Important To avoid errors when using dates, always use four-digit years. For more information about how FileMaker Pro handles two-digit dates, see Conversion of dates with two-digit years. |
| Example |
| GetAsDate("03/03/2009") returns 3/3/2009. You can perform date operations on this result. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > GetAsDate function |
|
|
Next Page |
|