in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
All Tags » Expressions (RSS)

Browse by Tags

  • Re: Contsupp.City field Date

    Hi Sukhdeep Sorry for misunderdstanding. the CITY field is a string, so the first thing is to extract the date: find(#CITY, "\d{8}") - extract a sequence of 8 digit characters Second is to convert this to a date: s2d(find(#CITY, "\d{8}"), "yyyyMMdd") - convert string to...
    Posted to Inaport (Forum) by admin on 03-18-2009

  • Exception thrown when evaluating function iif(.

    Hi David, I receive the following error when using 2 iif functions: iif(lcase(#[Name_title])='de heer','Male',iif(lcase(#[Name_title])='mevrouw','Female','Unknown')) Expression produced the following error: Exception thrown when evaluating function iif(. Exception...
    Posted to Inaport (Forum) by jaco1967nl on 02-02-2009
Page 1 of 1 (2 items)
InaPlex Limited 2008