DBPro Report Designer substr
Quote from CSSystems on February 8, 2023, 4:53 pmIn my Report with DBPro, I have a string field which I would like to display a substr of the field e.g. abcdef but I would like to display only abc.
Is there a way to do this?
In my Report with DBPro, I have a string field which I would like to display a substr of the field e.g. abcdef but I would like to display only abc.
Is there a way to do this?
Quote from CSSystems on February 8, 2023, 5:13 pmMy original question was to be" how to format a date field". I wanted to display only the day of the date until I realized I was using a String(12) field for my date.
Hence I changed my original question but I tried this on a date field with no success. There is no example I can find to accomplish what I am trying to do.
I understand the pipe character is used to accomplish this.
Can I get some help?
My original question was to be" how to format a date field". I wanted to display only the day of the date until I realized I was using a String(12) field for my date.
Hence I changed my original question but I tried this on a date field with no success. There is no example I can find to accomplish what I am trying to do.
I understand the pipe character is used to accomplish this.
Can I get some help?
Quote from CSSystems on February 9, 2023, 7:43 pmHow do I use these for Date and Time formatting. Such as picking off the month or day.
Doesn't seem to work for me in designing a report.
How do I use these for Date and Time formatting. Such as picking off the month or day.
Doesn't seem to work for me in designing a report.
Uploaded files:- You need to login to have access to uploads.
Quote from Vadim on February 9, 2023, 7:52 pm@cssystems
If you do a project in isolation showing the problem, it will be easier to understand what you need.
Show in the project how you do it and tell me what you want to get.
If you do a project in isolation showing the problem, it will be easier to understand what you need.
Show in the project how you do it and tell me what you want to get.
Quote from CSSystems on February 18, 2023, 7:46 pmI am include 2 screen shots. One is Report Design screen where I just want to display the birthday only next to the name. Second screen I would like that 'day' only to show next to the name. Date format is m/d/yyyy.
I am include 2 screen shots. One is Report Design screen where I just want to display the birthday only next to the name. Second screen I would like that 'day' only to show next to the name. Date format is m/d/yyyy.
Uploaded files:
- You need to login to have access to uploads.