cancel
Showing results for 
Search instead for 
Did you mean: 

PLD - formula field

keith_taylor2
Active Contributor
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member583013
Active Contributor
0 Kudos

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