• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

field date expression

Engaged ,
Oct 21, 2014 Oct 21, 2014

Copy link to clipboard

Copied

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,

TOPICS
Reporting

Views

551

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Advocate , Oct 21, 2014 Oct 21, 2014

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

Votes

Translate

Translate
Advocate ,
Oct 21, 2014 Oct 21, 2014

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Oct 21, 2014 Oct 21, 2014

Copy link to clipboard

Copied

LATEST

Thanks a million for helping and information,

Regards,

Iccsi,

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation