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 ) )
    }

     

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 ) )
}