Forum Discussion

matihernandez94's avatar
matihernandez94
Frequent Visitor
5 years ago
Solved

set hours

hi everyone, 

 

i need to set the hours of dates, for example if the day is 21/05/2021 05:35:20 i want change to 21/05/2021 10:00:00. And that for a lot of dates, always with the 10:00:00.

 

Hola a todos necesito cambiar el horario de las fechas en mis bases de datos, en las cuales si no estan dentro del horario laboral que es de (10:00:00 a17:00:00) cambie la hora a las 10:00:00. Ya que nose como modificar este campo.

 

Por ejemplo si es 21/05/2021 05:35:20 quiero cambiar ese campo al siguiente 21/05/2021 10:00:00.

 

 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    matihernandez94 

    Add the following calculated column to your table

     

    New Date and Time = INT(Table[Date]) + TIME(10,0,0)

     

     

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    matihernandez94 

    Add the following calculated column to your table

     

    New Date and Time = INT(Table[Date]) + TIME(10,0,0)

     

     

  • matihernandez94's avatar
    matihernandez94
    Frequent Visitor
    5 years ago

    thanks , 

    but in the editor of power query the funcion "int"  is not available

     

     

     

    how i can do that ? 😞 

    • Fowmy's avatar
      Fowmy
      Super User
      5 years ago

      matihernandez94 

      I thought you wanted a solution as a Calculated Column in the model. No issue, Please use the add custom column in Power Query and use the following code.