Sage 100

 View Only

  • 1.  Sage 2019 SQL & Business Insights Views

    Posted 07-10-2020 16:35
    Does anyone know of how to make this 1/1/1753 date show up as a blank or something on when using a UDF  fields in the Business Insights Explorer views?  Is this something that would need to be customized?


    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ------------------------------


  • 2.  RE: Sage 2019 SQL & Business Insights Views

    Posted 07-15-2020 17:55
    I think you could accomplish this with a calculated field.

    Here is the expression I used for the PVX version. The T-SQL will be slightly different.
    {fn REPLACE({fn CONVERT("CI_Item"."LastSoldDate", SQL_CHAR)}, '2020', '2025')}​


    I think this should work for Premium.

    IIF("CI_Item"."LastSoldDate" Is Null Or (Year("CI_Item"."LastSoldDate")=1799),NULL,"CI_Item"."LastSoldDate")


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



Related Content