you should just be able to subtract the two from o...
# suiteanalyticsk
KevinJ of Kansas
04/14/2020, 12:41 PMyou should just be able to subtract the two from one another
s
SMNCP
04/14/2020, 12:46 PMThis didn't work
k
KevinJ of Kansas
04/14/2020, 12:47 PMcan you be more specific with "didn't work"
KevinJ of Kansas
04/14/2020, 12:47 PMI.e. Error message when running search, error message on the column, wierd looking results?
s
SMNCP
04/14/2020, 12:48 PMNo results , formula (numeric) with {shiipdate}-{custcol_ship_date} returned blank.
k
KevinJ of Kansas
04/14/2020, 12:50 PMmaybe try
to_char({shipdate},'j') - to_char({custcol_ship_date},'j')b
battk
04/14/2020, 1:21 PMsomething weird is going on, this should be simple
a
Aria Ghahari
04/14/2020, 2:14 PMI have had issues with dates in the past. I had to convert them before being able to manipulate them. Add those 2 fields in your resultes using formula and see how they come up. They might be date/time
Aria Ghahari
04/15/2020, 3:49 PMThat worked btw. Thank you.
3 Views