Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Date Calculation


This topic is 7865 days old. Please don't post here. Open a new topic instead.

Recommended Posts

[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)

laugh.gifmad.giflaugh.gifmad.giflaugh.gifmad.giflaugh.gifmad.giflaugh.gifmad.giflaugh.gifmad.giflaugh.gifmad.giflaugh.gif I can't decide!

Link to comment
Share on other sites

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.