Anyone have the formula to get amounts between tra...
# suiteanalyticsj
Joseph Lee
10/26/2022, 10:48 PMAnyone have the formula to get amounts between trandates? Ive tried a few variations with no luck
v
virtualEncoreTremor
10/27/2022, 2:24 PMI've used this with the 'Round' function:
({datecreated} - {createdfrom.datecreated}) * 24virtualEncoreTremor
10/27/2022, 2:28 PMI've also had it where I had to cast the field as a date as well but I can't remember the context for why now. Perhaps worth a try if nothing else works?
cast({date_field} as date