- January 17, 2010 at 4:31 pm #31044
I am trying to convert the DOB field from PER in a report to show only the date, but I do not succeed using this: “cast(patientper.dob as DATE) as geboorte”. This shows the date as well as the time.
I have tried a lot, but nothing seems to work.
What command/format can I use in the source editor? Or is there a way to do the formatting in report design?January 18, 2010 at 9:36 am #32365
Thanks for the post. Which report are you trying to edit? The reason why i ask is with each report type (Layout/Grid/Document Template) there is a slightly different way of editing the date.January 19, 2010 at 11:23 am #32366
I am editing the Invoice report. I have added this to the source part of this report:
patientper.firstname, patientper.middlename, patientper.lastname, patientper.address1,
patientper.postcode, patientper.towncity, patientper.knownas,
patientper.dob, cast(patientper.dob as DATE) as geboorte,
So my question is about the last line. This line is based on the line “inv.datetime, cast(inv.datetime as date) as _invdate,” from the same report.January 20, 2010 at 2:09 pm #32367
Thanks for your post. It’s good to see that you are getting your hands dirty with SQL! 😀
 Click on the Reports and Templates button at the top of ClinicOffice.
 Right-click the Invoice report, and select Design Report.
 A new window will open up allowing you to edit the Invoice, left-click on the label which displays the Invoice Date. This will select the label and you’ll notice a small ‘smart tag’ appear at the top right of the box (it looks like a little arrow symbol “>”). Left click the ‘smart tag’ to bring up a menu.
 Click the button (with 3 dots …) next to the Format String
 Make sure DateTime is selected in the Category section. Click the Standard Types tab. You can then select from a list of options on how you want your date set out, including or excluding time. Once you’ve chosen your preferred option click OK. Then re-click the arrow symbol “< ".Alternatively, you can click the Custom formats tab (rather than the Standard Types) and simply select the “d” option, this stands for default which will use your Windows Regional Settings to display the date in the standard format.
I hope this helps!January 21, 2010 at 12:34 pm #32368
Thanks a lot. Now I can even reformat other fields.
You must be logged in to reply to this topic.