Date Diff formula

[Thant]

I have a formula im trying to get to work. it should show the difference between two time fields

DateDiff (d,{orders.order_date} {shipments.arrive_in_area} )

When i run this i get " the ) is missing and it places it after the d,.

Ive got to be missing something simple
thanks


Anything worth doing is worth messing up at least 5 times before you get it right!

 

[kray4660]

DateDiff (d,{orders.order_date}, {shipments.arrive_in_area} )

It appears you are missing a comma.

 

[Thant]

It is still saying the ) is missing
thanks

Anything worth doing is worth messing up at least 5 times before you get it right!

 

[lbass]

DateDiff ("d",{orders.order_date},{shipments.arrive_in_area})

Missing the quotes. This returns the difference in days.

"h" for hours
"n" for minutes //to distinguish it from "m" for months
"s" for seconds

-LB

 

[kray4660]

I looked too quick, thought I was missing something. Too many days off (vacation last week).