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(TOD...
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 ) )
    }

     

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.