Skip to main content
Inspiring
October 21, 2014
Answered

field date expression

  • October 21, 2014
  • 1 reply
  • 713 views

DateFormat(query.fromDay, "m/d") + "  "  + DateFormat(query.toDay, "m/d")

I wanted to show my report field like ' from 10/20/2014 to 10/25/2014 and have above code in the expression.

I got error when run the report.

It works for one expression like DateFormat(query.fromDay, "m/d"), but it does not work to combine 2 of them together.

Your help and information is great appreciated,

Regards,

Iccsi,

This topic has been closed for replies.
Correct answer EddieLotter

The plus sign is for adding numbers. Use the ampersand for concatenating strings.

1 reply

EddieLotter
EddieLotterCorrect answer
Inspiring
October 21, 2014

The plus sign is for adding numbers. Use the ampersand for concatenating strings.

iccsiAuthor
Inspiring
October 21, 2014

Thanks a million for helping and information,

Regards,

Iccsi,