How to calculate Days in Order?

[#1]

Hi,

can anyone suggest me please how can I calculate 'Days in Order' based on 'DateEnter'

I have a filed in table box 'DateEnter'  by using this filed I have to calculate 'Days in Order'

The 'DateEnter' field have values from 201 to current day.

Thanks.

[anbu1984]

Can you explain your requirement with example and expected output

[#3]

Thanks.

I have ID= 43242 sample DateEnter=20/08/2010 based on this date I need to calculate Days in Order

expected output

ID         Days in Order

674671   1118.98

76746     1118.98

67467     1118.98

[JonnyPoole]

Is 'Days in Order'  the number of days between today and the value of 'DateEnter' ?

If that is the case you do this to give you the number of days:

date(today()) - date(DateEnter)