How to show the text object as dynamic

[nareshthavidishetty]

Hi ,i want to show the text object as dynamic as per date.please find the image .

When ever the date field changes it will also changes dynamically.

[jagan]

Hi,

Try like this

='Traffic Store with a Traffic Counter MTD ' & Date(Today(), 'MMMM YYYY')

Regards,

Jagan.

[sushil353]

Hi,

If you have a date field and based on the selection on that date field, you need to change the text then try this:

='Traffic Store with a Traffic Counter MTD ' & Date(Max(DateField), 'MMMM YYYY')

HTH

Sushil

[nareshthavidishetty]

Thank you Sushil its working fine.

[nareshthavidishetty]

Thank you jagan its working fine.

[jagan]

Hi Naresh,

If you got the Answer please close this thread by giving Correct and Helpful answers to the posts which helps you.

Regards,

jagan.

[jagan]

Hi Naresh,

You should mark the posts as helpful which helps you in getting the Answers, but not your replies.  Close this thread by giving Correct and Helpful Answers to the posts which helps you in getting the answers.

Regards,

Jagan.