Have you tried using a text field with an auto-entered calculation?
FInd the field in Manage | Database | Fields and double click it's definition.
Copy the calculation expression.
Close the dialog and change the field type to text.
Double click it again.
Click the auto-enter tab
Select the calculation option and paste your expression into this field.
There are several options connected with this that you'll have to test and evaluate.
ah...you are a god send sir. These sinple things to you mean so much to me. Thank you for the assistance, adn thank god you are kind enough to share your knowledge with me two times in one day. I really appreciate it.
This is a good start to where i'm heading however it still does not get me to where I need to be.
Are you able to do this with a date? I've made a few fields - one to place the date from one field into another that has been changed to a text type. I made another field using the same information provided above - but it will not pick up the date that is now in a text type field.
Basically I need to be able to alter the date if need be without changing the original date that's indicated in the other field. The field that I need the date to appear must be a date field due to it being used in a script that finds the date range.