Dynamic lables in table

[vireshkolagimat]

Hi,

I have a straight table and it contains the below fields in the order.

Week ending 1-1-2016

Month

Quarter

Year

I have added all four fields in the expressions tab and given the label manually. How to get the labels dynamically if there is change in the name of the column. Suppose if [week ending 1-1-2016] changes to [week ending 1-10-2016].

Thank You.

Regards,

Viresh

[miguelbraga]

Hi Viresh Kolagimath,

What does your field [week ending 1-1-2016] reflects in the script? If you change Month, Quarter and Year it will make changes in your field? If yes, then a plausible answer is:

Put in the label the following expression:

= '1-' & max(Month) & '-' & max(Year)

Regards,

MB

[vireshkolagimat]

Hi,

The field name itself [week ending 1-1-2016] and i'm reading the this field as it is in edit script.

Regards,

Viresh

[miguelbraga]

Change my previous solution to this:

Put in the label the following expression:

= '[Week ending 1-' & max(Month) & '-' & max(Year) & ']'

Hope this helps

Regards,

MB

[Pulkit_Thukral]

Try something like this

='Week Ending - ' & Date(Weekend(MAX(Datefield)),'MM-DD-YYYY')

or

'Week Ending - ' & Date(Weekend(today()),'MM-DD-YYYY') if this suits you.