on 09-17-2008 6:40 PM
Can someone please tell me how in print layout designer I can display a new date field based on a calculation of another date field.
For example take a date and subtract 5 weeks or 35 days so if deldate = 09/01/08 display the date 5 weeks earlier.
Is this possible in PLD? If not then I guess I could create a new udf on the marketing row and calculate the date and then display it on the form.
Ideas?
The formula field in PLD can do mormal calculation but date function support is not there. The UDF displays in the PLD will be your right solution.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Keith,
You can actually do days.
Let us suppose your date field is Field_175 (typically Posting date on Sales Order)
You can have a Formula field with the formula
Field_175 - 30
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.