Trigger Actions for Two Fields

[#1]

Hi All,

My requirement is by default the year  = current year and period =  current period.

I have created two trigger actions.One for Year and the other one for Period.

Year is working but not period.Can anyone help me on this.

[#2]

Hi,

Do you have possibility to upload a sample?

[agilos_mla]

Please attached a sample.

The issue is probably due to a date format, do you use select in Field Period, max(Period)?

[Anonymous]

Would making a single concatenated field of Year & Period help ?

[Anonymous]

What is "period" and how the action looks like?

[Clever_Anjos]

Is your period field related to year?

If so, be carefull about your expression on second action

[#7]

Hi All,

Here is the attached sample file.Thanks in advance.

[Clever_Anjos]

Try =MAXSTRING([Calendar Period])

[#9]

MAXSTRING([Calendar Period]) is not working.

[agilos_mla]

Cast you Calendar Period in a dual :

Dual(

     IF (FISCAL_PERIOD = 1,'P1',

     IF (FISCAL_PERIOD=2,'P2',

     IF (FISCAL_PERIOD = 3, 'P3',

     IF (FISCAL_PERIOD = 4,'P4',

     IF (FISCAL_PERIOD = 5,'P5',

     IF (FISCAL_PERIOD = 6,'P6',

     IF (FISCAL_PERIOD = 7,'P7',

     IF (FISCAL_PERIOD = 8,'P8',

     IF (FISCAL_PERIOD = 9,'P9',

     IF (FISCAL_PERIOD = 10,'P10',

     IF (FISCAL_PERIOD = 11,'P11',

     IF (FISCAL_PERIOD = 12,'P12',

     IF (FISCAL_PERIOD = 13, 'P13'))))))))))))), ((FISCAL_YEAR-1)*13) +FISCAL_PERIOD)  AS 'Calendar Period'

then using Max([Calendar Period]) in a select in Field action should do the trick.