How to find number of days between 2 dates in the same FIELD?

[Guest]

I want to how is it possible to find out days between 2 dates in one field.

Eg.

[Sales Made On] is a date field with following values:

10/10/2004
10/15/2004
10/19/2004

How can I find the days lapsed between 2 consecutives values in the above
given field?

Thanks.

 

[Mike Painter]

I want to how is it possible to find out days between 2 dates in one
field.

Eg.

[Sales Made On] is a date field with following values:

10/10/2004
10/15/2004
10/19/2004

How can I find the days lapsed between 2 consecutives values in the
above given field?

BAD, bad, bad idea.
Each of those dates should be in a separate row and should be date fields.

To do it in one field you will need to know what the delimiter between the
values are and then collect them into separate variables using Mid() and
Instr() to find the delimiter.
Next step is to make sure they are valid dates, then use dateDif to
determine the difference.