Special Fields

[ianholmes]

Is there a Special Field which will pick up a date from a database row, and compute the number of days between it and today ? (Version XI )
Thanks I'm new to this

 

[lbass]

Use a formula like:

currentdate-{table.date}

-LB

 

[mjjks]

You could also use DateDiff ("d",CurrentDate,{Table.DateField})

LB, does Crystal default to days when you do it like in your example?

 

[lbass]

Yes.

-LB