Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Calendar Table Only Showing One Date

Hi All,   I created a calendar table but it only shows one date? What am I doing wrong?     Thanks
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi HenryJS 

    I think its a wrong date format question

    try

    Table = CALENDAR( DATE(2001,1,1), DATE(2021,1,1) )

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    HenryJS 

     

    The same as below.

    Table 2 =
CALENDAR (
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2001 ), DATETIME ),
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2021 ), DATETIME )
)

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

HenryJS 

 

The same as below.

Table 2 =
CALENDAR (
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2001 ), DATETIME ),
    CONVERT ( DIVIDE ( DIVIDE ( 1, 1 ), 2021 ), DATETIME )
)