Date Calculation

[tallboy755]

[color:"blue"] Hello .... folks ....Its been a while sence i've posted anything, so here it goes.

I have Field A (date field - autoenter Creation Date) and Field B (text)... I need (: to have the number of days past the creation date entered in it (1, 2, 3, 4 ext)

I can't decide!

[plechton]

Simplest would be to make Field B a calculation, and give it the formula

Status(CurrentDate) - FieldA

but if you need it to be a text field for some reason, then maybe put in your start script

Set Field [FieldB, Status(CurrentDate) - FieldA]

HTH

Pauline

[tallboy755]

thanks .... that will work ... I will just set my calculation to return text ...

[cjaeger]

no need for startup skripts. But somehow you will have to have

a) either auto-enter with self-relationship based on unique IDs (serialnumbers)

B=A

: Num2Text(Status(CurrentDate) - FieldA) <unstored>

but why a text field? or do you needit as a key to past dates?