18 Replies Latest reply: Dec 6, 2017 3:00 PM by Sunny Talwar RSS

    MonthStart flag in Load script

    William Fu

      The following script line is giving me an invalid expression error in the load script


      If(Date(Date#([DtReferencia], 'YYYYMMDD')) = MonthStart(Max(Date(Date#([DtReferencia], 'YYYYMMDD')))), 1, 0) as FlagCurrentDtRef,


      The flag is meant to filter the first day of the most current month in the database.

      Can anyone spot the error?