Support

Lyza handles Dates in an intuitive, context-sensitive manner. In some situations, it is natural to treat a date as a number, while in others it is natural to treat it as a text string. Note: In Lyza, a date is a number on a timeline. To be precise, it is the number of milliseconds since midnight on January 1, 1970. However, it is possible to convert this number to a meaningful text string - a readable, calendar-based date/time label. Throughout Lyza, when we refer to a date value, we are talking about a number on a timeline. This number is used to perform date calculations, such as adding 5 days to a date, or subtracting two dates. By default, Lyza does not display dates as numbers; it displays them as formatted text. So, when we refer to a formatted date, we are talking about the readable, meaningful text string to which a date value has been converted.

If any records have been dropped during the import process, the data connection icon will glow yellow. This is to alert you that records have been dropped, and to encourage you to investigate. It is helpful to underscore the reasons why a record might have been dropped. 1. A value in a particular cell does not match the data type of the column. This is the most common cause for dropping a record. 2. A record does not contain the right number of columns.