tallboy755 Posted April 23, 2003 Share Posted April 23, 2003 [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! Link to comment Share on other sites More sharing options...
plechton Posted April 23, 2003 Share Posted April 23, 2003 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 Link to comment Share on other sites More sharing options...
tallboy755 Posted April 23, 2003 Author Share Posted April 23, 2003 thanks .... that will work ... I will just set my calculation to return text ... Link to comment Share on other sites More sharing options...
cjaeger Posted April 23, 2003 Share Posted April 23, 2003 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? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7865 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now