5 Replies Latest reply: Nov 2, 2018 3:04 AM by Petter Skjolden RSS

    Create EndMonth Flag in Script

    Scott Allen

      Hello,

       

      I am trying to flag when a date is an End of Month date with an if statement.  It appears the syntax is correct, but my results are returning an 'N' on the last day of the month.  Here is the script:

       

      if(Date(MonthEnd([Census_Daily.CensusDate],'YYYY-MM-DD')=[Census_Daily.CensusDate],'YYYY-MM-DD'),'Y','N') as vIsCensusMthEnd,

       

      Any suggestions are most appreciated.  Thank you!

       

      Census EOM Flag.PNG