Forum Discussion

luisecp's avatar
luisecp
Frequent Visitor
4 years ago
Solved

Create a table that increase 1 hour since a date until today ()

I want to create a table that increase 1 hours since one date "01/01/2021" until now

 

Datetime

01/01/2021 00:00:00

01/01/2021 01:00:00

01/01/2021 02:00:00

01/01/2021 03:00:00

01/01/2021 04:00:00

.

.

.

TODAY

 

 

 

Regards

 

Luis

calendar
Date
hour
time
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi luisecp 

     

    Try this code to create a new table:

     

     

    Table = 
GENERATESERIES ( DATE ( 2021, 01, 01 ), NOW (), TIME ( 01, 00, 00 ) )

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi luisecp 

     

    Try this code to create a new table:

     

     

    Table = 
GENERATESERIES ( DATE ( 2021, 01, 01 ), NOW (), TIME ( 01, 00, 00 ) )

     

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi luisecp ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.