Sumit kumar thakur

[#1]

If i select year and month, is it possible that the first day of that month and year gets selected automaticallly.

if yes give the solution

[CELAMBARASAN · Accepted solution]

Hi,

     Use trigger(On select) for the both year and month fields which you can found in the document properties-->Triggers tab.

     Action:Select in field

     Field Name:DateField

     Search String:=if(GetSelectedCount(Month)>0 and GetSelectedCount(Year)>0, MakeDate(Max(Year), Max(Month), 1 ))

Hope it helps

Celambarasan

[#3]

The answer u have given me works correctly when i select monthname and year, but when i select financialyear instead of normal year it gives the following result ---

i select financial year = 2009-2010 and month = sep , it show 01/09/39904

[CELAMBARASAN]

Hi,

     Check what this expression returns on selecting financial year?

     =Max(Year)

     Did you used the above expr or Max(FinancialYear)?

Celambarasan

[#5]

i have try out this expression

if(GetSelectedCount(MonthName)>0 and GetSelectedCount(FinancialYear)>0, MakeDate(Max(FinancialYear), Max(MonthName), 1 ))

and output is 01/09/39904

[CELAMBARASAN]

Hi,

     Do you have a year field?

     if so use that year field instead of Financial Year.

     Check with the below expr.

if(GetSelectedCount(MonthName)>0 and GetSelectedCount(FinancialYear)>0, MakeDate(Min(Year), Min(MonthName), 1 ))

Celambarasan