IRISLIB database
FilemanDate Class Reference

Custom DATE data type designed to convert FILEMAN format (CYYMMDD) dates. More...

Static Public Member Functions

_.Library.FilemanDate DateToLogical (_, _.Library.String val)
 Converts Date format DATE (+$H) to FILEMAN format DATE (CYYMMDD).
 
_.Library.FilemanDate DisplayToLogical (_.Library.String Arg1)
 Converts DISPLAY format DATE (DD/MM/YYYY) to FILEMAN format DATE (CYYMMDD).
 
_.Library.Status IsValid (_, _.Library.RawString val)
 Checks for Invalid format, expects FILEMAN format DATE (CYYMMDD). More...
 
_.Library.Date LogicalToDate (_, _.Library.FilemanDate val)
 Converts FILEMAN format DATE (CYYMMDD) to Date format DATE (+$H)
 
_.Library.String LogicalToDisplay (_.Library.FilemanDate Arg1)
 Converts FILEMAN format DATE (CYYMMDD) to DISPLAY format DATE (DD/MM/YYYY). More...
 
_.Library.String LogicalToJSON (_, _.Library.FilemanDate val)
 Converts the logical FilemanDate value to the JSON string value.
 
_.Library.String LogicalToOdbc (_.Library.FilemanDate Arg1)
 Converts FILEMAN format DATE (CYYMMDD) to ODBC format DATE (YYYY-MM-DD). More...
 
_.Library.String LogicalToXSD (_, _.Library.FilemanDate val)
 Converts the FilemanDate value to the canonical SOAP encoded value.
 
_.Library.FilemanDate OdbcToLogical (_.Library.String Arg1)
 Converts ODBC format DATE (YYYY-MM-DD) to FILEMAN format DATE (CYYMMDD).
 
_.Library.FilemanDate TimeStampToLogical (_, _.Library.TimeStamp val)
 Converts TimeStamp format TIMESTAMP (YYYY-MM-DD HH:MM:SS) to FILEMAN format DATE (CYYMMDD).
 

Static Public Attributes

 STRICTDATA = None
 1/0 flag which determines if the LogicalToFormat conversions will process imprecise logical FileMan Date values More...
 

Detailed Description

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 function

Member Function Documentation

◆ IsValid()

_.Library.Status IsValid (   _,
_.Library.RawString  val 
)
static

Checks for Invalid format, expects FILEMAN format DATE (CYYMMDD).

Can handle data on disk in the Fileman TimeStamp format.

◆ LogicalToDisplay()

_.Library.String LogicalToDisplay ( _.Library.FilemanDate  Arg1)
static

Converts FILEMAN format DATE (CYYMMDD) to DISPLAY format DATE (DD/MM/YYYY).

Can handle data on disk in the Fileman TimeStamp format.

◆ LogicalToOdbc()

_.Library.String LogicalToOdbc ( _.Library.FilemanDate  Arg1)
static

Converts FILEMAN format DATE (CYYMMDD) to ODBC format DATE (YYYY-MM-DD).

Can handle data on disk in the Fileman TimeStamp format.

Member Data Documentation

◆ STRICTDATA

STRICTDATA = None
static

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.