%Library.FilemanDate
datatype class %Library.FilemanDate
ODBC Type: DATE
Custom DATE data type designed to convert FILEMAN format (CYYMMDD) dates. This data type projects proper DATE meta-data to DISPLAY and ODBC client software. It does not require any extra routines to functionMethod Inventory
- DateToLogical()
- DisplayToLogical()
- IsValid()
- JSONToLogical()
- LogicalToDate()
- LogicalToDisplay()
- LogicalToJSON()
- LogicalToOdbc()
- LogicalToXSD()
- OdbcToLogical()
- TimeStampToLogical()
- XSDToLogical()
Parameters
parameter JSONTYPE = string;
parameter STRICTDATA = 0;
1/0 flag which determines if the LogicalToFormat conversions will process imprecise logical FileMan Date values
Default setting is STRICTDATA=0
Parameter affects the generation of the LogicalToDisplay and LogicalToOdbc methods
When STRICTDATA=1, imprecise or invalid dates will not be changed to a valid FileMan Date value.
For example, if Logical FileMan Date value is 31110, when STRICTDATA=0 this will translate to 3111001 (Sept 01, 2011).
If STRICTDATA=1, this transformation will not take place and the invalid/imprecise Logical value will get an error when converted to Display or Odbc format.
parameter XSDTYPE = date;
Methods
classmethod DateToLogical(%val As %Library.String) as %Library.FilemanDate
Converts %Date format DATE (+$H) to FILEMAN format DATE (CYYMMDD).
classmethod DisplayToLogical(Arg1 As %Library.String) as %Library.FilemanDate
Converts DISPLAY format DATE (DD/MM/YYYY) to FILEMAN format DATE (CYYMMDD).
classmethod IsValid(%val As %RawString) as %Status
Checks for Invalid format, expects FILEMAN format DATE (CYYMMDD).
Can handle data on disk in the Fileman TimeStamp format.
classmethod JSONToLogical(%val As %String) as %FilemanDate
classmethod LogicalToDate(%val As %Library.FilemanDate) as %Library.Date
Converts FILEMAN format DATE (CYYMMDD) to %Date format DATE (+$H)
classmethod LogicalToDisplay(Arg1 As %Library.FilemanDate) as %Library.String
Converts FILEMAN format DATE (CYYMMDD) to DISPLAY format DATE (DD/MM/YYYY).
Can handle data on disk in the Fileman TimeStamp format.
classmethod LogicalToJSON(%val As %FilemanDate) as %String
Converts the logical %FilemanDate value to the JSON string value.
classmethod LogicalToOdbc(Arg1 As %Library.FilemanDate) as %Library.String
Converts FILEMAN format DATE (CYYMMDD) to ODBC format DATE (YYYY-MM-DD).
Can handle data on disk in the Fileman TimeStamp format.
classmethod LogicalToXSD(%val As %FilemanDate) as %String
Converts the %FilemanDate value to the canonical SOAP encoded value.
classmethod OdbcToLogical(Arg1 As %Library.String) as %Library.FilemanDate
Converts ODBC format DATE (YYYY-MM-DD) to FILEMAN format DATE (CYYMMDD).
classmethod TimeStampToLogical(%val As %Library.TimeStamp) as %Library.FilemanDate
Converts %TimeStamp format TIMESTAMP (YYYY-MM-DD HH:MM:SS) to FILEMAN format DATE (CYYMMDD).
classmethod XSDToLogical(%val As %String) as %FilemanDate