Forum Discussion
Split value in column with multiple dates
Hey guys, i used a code that i found over the forum and it worked perfectly. However its missing one step that i need it to do it. The code that im using is to separate the dates if it changes the da...
Hey, jokas10
in custom3 add the #duration and in custom4 subtract the duration.
for example for custom3 = ...... [Rows]-1 ) + #duration(6,0,0,0)), type datetime),
same for the custom4, just use subtract. custom4 = .......(1/86400)) - #duration(6,0,0,0), type datetime),
See if this works.
refer: https://learn.microsoft.com/en-us/powerquery-m/sharpduration
Hey my friend, thanks for the response but it didnt work.
It needs to be like:
24/07/2023 09:25:03 ----> 25/07/2023 5:59:59
25/07/2023 06:00:00 ----->26/07/2023 5:59:59
26/07/2023 06:00:00 ----->26/07/2023 13:07:54