Date Format in Fast Report

JohnxpJohnxp
edited 10:50AM in FastReport .NET
Hi,

I have application where user selects date (local date format), then I send this formula to Fast Report.

The problem occur when I run the application from machine set with US date format (mm/dd/yyyy), in this case Fast Report will read the passed date like (dd/mm/yyyy).

How can I set the Date/Time format in Fast Report.

Thank you,

Comments

  • AlexTZAlexTZ
    edited 10:50AM
    Hello,

    How do you pass the format to FastReport?
  • JohnxpJohnxp
    edited 10:50AM
    AlexTZ wrote: »
    Hello,

    How do you pass the format to FastReport?

    I pass it as string (sql):

    WHERE callhistory.endtime>= (timestamp '31/5/2009')

    I use Postgresql Database.
  • AlexTZAlexTZ
    edited 10:50AM
    If you pass a date to sql, you should use the date format that your server understands. FastReport does not convert it in any way.
  • JohnxpJohnxp
    edited 10:50AM
    AlexTZ wrote: »
    If you pass a date to sql, you should use the date format that your server understands. FastReport does not convert it in any way.

    Thank you Alex.

    So, it's Postgres issue then :-)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024