Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Day of the week in the report

edited June 2005 in General
I have a datetime field in my sql DB.
is there a way to add a field in my report that will show the day (sunday,
monday ...) according to that field?

Comments

  • edited June 2005
    Just use a TppVariable. In the OnCalc event, call this:

    Value := DayOfWeek(Report.DataPipeLine['MYDATETIMEFIELD']);

    David

    "Matt Harper" a ?crit dans le message de
  • edited June 2005
    Hi Matt.

    All you need to do is just place the DBText in the design area (which
    reads the field data from your DB) and specify a "Display format" as dddd.

    And that's it.

  • edited June 2005
    Thanks, had no idea its so simple

    Thank you also David.

This discussion has been closed.