Forum Discussion
Time Range
Hi, I wrote the following formula and created a custom column: =if[AccountCreationTime]>=[Terms_Shay.Leads Start Time] and [AccountCreationTime]<=[Terms_Shay.Leads End Time] then 1 else 0 The result ...
The time data type only spans 24h so everything is considered in the same day by PQ. You would need additional data to specify if that is not the case. If the time is on the current date as you say, your initial code should work.
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |