Skip to main content
Inspiring
October 21, 2014
Answered

field date expression

  • October 21, 2014
  • 2 replies
  • 719 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 is closed to new replies. Start a new post to keep the conversation going.
Correct answer EddieLotter

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

2 replies

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,