Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create Table 1 row multiple columns

Hello,

 

How do you create a table with 1 row and multiple columns with data?

 

I am trying to get this into a table
EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1 ), -1)
EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1),-2)

I've had a go at using the DATATABLE function, had no success.

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    This works:

    new table =
    {
    ( EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -1 ), EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -2 ) )
    }

     

6 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    Anonymous 

    Quesion is bit unclear! Can you share a snapshot how you want to see the data!

    Matrix table should help you right?!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,
      This is what I want to see if the date is 11 September 2022.

       

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        3 years ago

        This works:

        new table =
        {
        ( EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -1 ), EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -2 ) )
        }

         

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    3 years ago

    Try

    {(EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1 ), -1),
    EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1),-2)}

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,

      Thanks for your input.

       

      I have tried this also, which gave me this error.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is the error I get when using the DATA Table Function.