Forum Discussion

Ghaston's avatar
Ghaston
Helper I
7 years ago
Solved

Creating Date/Time calendar

Hi guys !    I have a date/time column " Date_Heure" dans la table "SGD_CPT_LIGNE_LIVE_VUE" and another one that has the same name in "SGD_CPT_LIGNE_HISTO_VUE".  I want to create a date/time table...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Ghaston,

    Please check the code in the advanced language like the picture below:

    The duration should from a smaller value, so you need modify the code from the B{0}[Column1].

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Ghaston,

I have reproduecd your problem. You could check the code in the advanced language, when you are using the Duration.from function, the parameter should be a bigger one to minus a smaller one, see the picture post below, if you used a smaller one to minus the bigger one, it will show the same error, I suggest to check the value and modify the code.

 

Regards,

Daniel He

Ghaston's avatar
Ghaston
Helper I
7 years ago

Hi v-danhe-msft

you were right! i had to modify the code like you showed me. 
I don't get that error now, but instead, i get a calendar that starts from my bigger column (date/time in column A) , to 2021 ! 
I verified my A and B tables, and they are fine.  
 

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Ghaston,

    Please check the code in the advanced language like the picture below:

    The duration should from a smaller value, so you need modify the code from the B{0}[Column1].

     

    Regards,

    Daniel He

    • Ghaston's avatar
      Ghaston
      Helper I
      7 years ago

      v-danhe-msft, thanks ! 
      it worked perfectly 
      thanks for your time :)