text - any
text expression or text
field containing text in the same format as the date on the system where the file was created
Use the GetAsDate or
Date function to enter a date
constant into a formula. The format of
text date must be the same as the date format on the system where the file was created.
GetAsDate(“03/03/2014”) returns
3/3/2014. You can perform date operations on this result using the
Date function.
GetAsDate(735516) returns
10/10/2014. The number 735516 specifies the number of days since 1/1/0001.
GetAsDate(EndDate) - GetAsDate(StartDate) returns
90 if the value in the field
EndDate is 4/1/2010 1:00 AM and the value in the field
StartDate is 1/1/2010 11:15 PM.