0

Text to Dynamic Caption

Hi

 

Hopefully an easy one, im looking to add the word "and Prior" to the following dynamic caption text

ToString(DateFormat(AddYears(Date(),-2), "YYYY") )

I did think it would be ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) & " and Prior"

Any help much appreciated

 

Thanks

 

Nick

2 replies

null
    • VP Product Management
    • Ian_Macdonald
    • 4 yrs ago
    • Reported - view

    Simply use the concatenation operator "+" thus:

        ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) + " and prior"

    Note, DateFormat() returns a string, so the ToString() function is redundant.

    Hope that helps,

    Ian

    • Nicholas_Campbell
    • 4 yrs ago
    • Reported - view

    Thanks Ian, much appreciated

Login to reply

Content aside

  • Status Answered
  • 4 yrs agoLast active
  • 2Replies
  • 45Views
  • 3 Following