Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Change date by time

Hello all.   I have two columns "Date" and "Time". I need to add a third column with the date "New Date". The date should change not at 00:00 but at 06:00.   Example: Weighing date March 1, 202...
  • tamerj1's avatar
    3 years ago

    Hi Anonymous 

    you may try

    New Date =
    DATEVALUE (
    'Table'[2nd Weight Date] + 'Table'[2nd Weight Time]
    - TIME ( 6, 0, 0 )
    )