How Do I Calculate a Date Value that Is Stored in a String? (Magic xpi 4.1)

In most cases, Magic xpi will handle date conversion issues for you. That is, when you are displaying a date on a form, reading a date with a form, or reading it from a data source, you don’t need to manually do the conversion. There are a few scenarios where you may have to parse a string to extract the date, however.

In those cases, you need to use the DVal() function. This function uses pictures to interpret the string and find its date equivalent. It is up to you to be sure that the picture matches the date format in the string. For instance:

See also: How Do I Convert a Date Value to a String?