Date Minu Day

[Deimantas]

Hi Guys, 

Unofrnutultey I can't find opened thread for this issue.

All I'm trying to use is if the function and the return value are true should be the date column -1 day if false return the same day. 

At first, I try to use: 

if [Hour]>=0 and [Hour]<=5 then [Date]-1 else [Date]  

But true value returnins if fales (because formating of the statemtn won't match ) 

The i try :

if [Hour]>=0 and [Hour]<=5 then Text.From(DateTime.Date(Date(Date.AddDays([Date],-1)))) else [Date]

Unfortunutelly still have error. 

Please help! 

[BA_Pete · Accepted solution]

Hi @Deimantas ,

This should work:

if [Hour] >= 0 and [Hour] <= 5 then Date.AddDays([Date], -1) else [Date]

Pete

[Deimantas]

Thank you for your replay, it's working! 

Thanks.