Forum Discussion

Deimantas's avatar
Deimantas
Frequent Visitor
3 years ago
Solved

Date Minu Day

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! 

  • Hi Deimantas ,

     

    This should work:

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

     

    Pete

2 Replies

  • Hi Deimantas ,

     

    This should work:

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

     

    Pete

    • Deimantas's avatar
      Deimantas
      Frequent Visitor

      Thank you for your replay, it's working! 

      Thanks.