Unless i'm missing something, can't you just subtr...
# suiteanalyticsg
Gregory Jones
03/20/2020, 5:47 PMUnless i'm missing something, can't you just subtract one from the other in a formula numeric? That will give you days between, then you can multiply by 1440 to get minutes, or 86400 to get seconds
d
dbarnett
03/20/2020, 5:50 PMfrom what I am seeing at least, a simple subtraction even as a Formula(Numeric) type gives a value such as "+000000001 044447.000000" , where multiplying by 1440 for instance then gives "+000001724 184800.000000000"
g
Gregory Jones
03/20/2020, 5:51 PMOh, maybe it's that you're using custom fields - i have something that does it with native fields...maybe that's where there is a difference in output.
Gregory Jones
03/20/2020, 5:55 PMBut even then, doesn't make sense unless the native fields are different somehow to date/time custom fields.
d
dbarnett
03/20/2020, 5:56 PMyes, I did an experiment with like {now} & {lastmodifieddate} and those behave as you are describing, so not sure why custom DateTimes seem to behave differently