Forum Discussion
Solved
If condition not working for Dates
Hi Everyone, I have two tables 'Sales' & 'Customers'. There is a Date column in Sales table with the name "SalesDate" that I want to add hours based on the Customers locations. The Customers tabl...
bIearner83 , a new column in the sale table
= if(related(customer[Name]) = "bunnings" , [sales date] + time(8,0,0) , [Sales Date])
amitchandak
Super User
Super UserbIearner83 , a new column in the sale table
= if(related(customer[Name]) = "bunnings" , [sales date] + time(8,0,0) , [Sales Date])
Thank you. That worked. Thanks to you and amitchandak as well.
