How to derive no. of days from date field.

[#1]

Hi folks,

Situation is I want to calculate the no. of days a person been actively using a service. Based on a customers earliest period (date) of using the service till the current date of their usage, I would like to compute the no. of days.

Any idea on how to do so? Sample script?

Please advise. Thank you.

Best Regards,

R

[alexandros17]

If you have 2 dates and you need to compute N° of days between them, simply

Num(Date2) - Num(Date1) gives you the number of days

[#3]

Like this

=Date(Today())-Date(today()-100)

Note: Change according to your usage.

[tresesco · Accepted solution]

Take a straight table; Customer as dimension; expression, something like: Max(Date)-Min(Date)

It all depends on your data, how your records are being stored.

[#5]

That just doesn't make any sense to me.

[#6]

Thanks once again tres! Your a legend.