JoseQuiervo
Programmer
I have a field $12 and $11, and I want the difference of the two. However, I want to convert them from a string to a date field first...how can I do that?
Thank you!
Thank you!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
R5 - In a view, subtracting two formula fields
- Thread starter JoseQuiervo
- Start date
- Status
In your Designer Help database, go to the Index, down to Column, choose the option "programmatic name for", then choose "Advanced options for columns".
In that article, it is said that "If you first define a column using a simple function, then you create another column that depends on the value of the first, you must edit the programmatic name of the first column to something other than a dollar symbol ($) and a number".
In other words, to do column formulas that depend on the result of other columns, you must assign a name to the column that is the source for the other column.
Then you can do your calculation.
Pascal.
In that article, it is said that "If you first define a column using a simple function, then you create another column that depends on the value of the first, you must edit the programmatic name of the first column to something other than a dollar symbol ($) and a number".
In other words, to do column formulas that depend on the result of other columns, you must assign a name to the column that is the source for the other column.
Then you can do your calculation.
Pascal.
- Status
Similar threads
- Locked
- Question