Forum Discussion
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...
Hi Anonymous
you may try
New Date =
DATEVALUE (
'Table'[2nd Weight Date] + 'Table'[2nd Weight Time]
- TIME ( 6, 0, 0 )
)
tamerj1
Community Champion
Community ChampionHi Anonymous
you may try
New Date =
DATEVALUE (
'Table'[2nd Weight Date] + 'Table'[2nd Weight Time]
- TIME ( 6, 0, 0 )
)
Thanks a lot for help, now it's working.