a smaller date minus a larger date is probably not...
# suiteanalyticsb
battk
04/26/2019, 11:41 PMa smaller date minus a larger date is probably not what you want
m
mg2017
04/27/2019, 8:15 AMreversed the dates but still something not quite right: 24/04/2019 11:13 24/04/2019 141454 = 0
b
battk
04/27/2019, 8:47 AM24/04/2019 11:13 is a smaller date than 24/04/2019 141454
battk
04/27/2019, 9:42 AMalthough to be honest, i don't think that really matters. you should be getting something other than 0
battk
04/27/2019, 9:42 AMwhat formula are you using?
m
mg2017
04/27/2019, 11:45 PMFormula (numeric)
b
battk
04/28/2019, 12:29 AMI meant the actual formula for the column
m
mg2017
04/28/2019, 9:30 AMAh ok
mg2017
04/28/2019, 9:31 AM(to_date({custrecord_job_start}, 'DD-MM-YYYY hh24:mi') - to_date({created}, 'DD-MM-YYYY hh24:mi')) * 24
b
battk
04/28/2019, 8:05 PMI wouldn't trust the implicit conversion going on there
battk
04/28/2019, 8:06 PMGive it a try without the to_date
battk
04/28/2019, 8:06 PMI don't think it will give exactly what you want, but it should be better than 0
battk
04/28/2019, 8:12 PMIf that works out better, you can try doing the char conversion yourself using to_char
m
mg2017
04/28/2019, 10:41 PMremoving the conversion produces an unexpected error: ({custrecord_job_start} - {created}) * 24
b
battk
04/28/2019, 11:36 PMwhat type of field is custrecord_job_start? If its a date/time field, subtracting created from it should give you an interval
m
mg2017
04/29/2019, 7:51 AMboth fields are date/time - so was hoping it should give me a correct time difference
b
battk
04/29/2019, 12:00 PMAre you sure you are not doing something strange? Subtracting a date from a timestamp gives an interval. And explictly converting the timestamp to a char and then to a date makes the subtraction return a difference in days
battk
04/29/2019, 2:17 PMmessage has been deleted
m
mg2017
04/29/2019, 2:53 PMthanks - got the hours from the date