How to get the field value?

[#1]

Hi All,

I have the following records.

load * Inline

[

FiscalWeek,WeekDate

2011Wk01,2011/01/01

2010Wk01,2010/01/01

]

And I have a variable named 'vWeekDate', the default value of it is '2010/01/01'.

I want to show the FiscalWeek name in the textbox, and it is changed based on the 'vWeekDate'.

How to achieve it?

[#2]

Try this expression in the textbox if you want a unique value:

=Only({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

or if you want the max value by default:

=MaxString({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

or if you want the min value by default:

=MinString({< [WeekDate] = {$(vWeekDate)} >} Fiscal Week)

With an example I can help you more accurate.

[christophebrault]

If WeekDate is unique datas, you can use :

FieldValue('FiscalWeek',FieldIndex('WeekDate',vWeekDate))

see exemple

[#4]

The weekdate is not unique, how to achieve it?

[SunilChauhan]

see the attced file

hope this helps