Current Period

[#1]

I have a field named fiscalNumber having 1-13 periods.

But i want the current period means period of today().

I want something like this

Max({<Calendar_Date={'16/10/2014'}>} FiscalPeriodNumber)

Please help. Its urgent.

Thanks !!!!!!

[MK_QSL]

Only({<Calendar_Date={'$(=Today())'}>} FiscalPeriodNumber)

[#3]

it returning null value.

[MK_QSL]

Provide sample data please..

[#5]

max({<Calendar_Date={'$(=Today())'}>}FiscalPeriodNumber)

[simondachstr]

Create a textbox and type in the expression =today().

See if the format of today() matches your Calendar_Date field. If yes, check then if one Calendar_Date can have multiple FiscalPeriodNumbers...

[its_anandrjs · Accepted solution]

Try this way also

=Max({<Calendar_Date={'$(=Max(Today()))'}>} FiscalPeriodNumber)

Or

=Only({<Calendar_Date={'$(=Max(Today()))'}>} FiscalPeriodNumber)

[simondachstr]

Max(today()) ?!?

[#9]

Hi,

As per anand specified expression should work if it not please check your data by taking two fields in layout  whether association is coming or not..Also check fieldValue for CalendarDate..