Date Time
      Back to home
      1. Help Center
      2. Date Time

      Beginning of Month

      Returns the 1st day month from a date

      Function:

      BegMonth(table = string, col = string, new_col = string)

       

      Parameters:

      Table: Table name on which to perform function

      Date Column: Column to select to find the 1st day of the month

      New Column Name: Name for the new column

       

      Examples:

      BegMonth(table = Budget, col = "Date", new_col = "1st day")