Topic
3 replies Latest Post - ‏2010-07-15T22:51:00Z by Duckster
sobha
sobha
13 Posts
ACCEPTED ANSWER

Pinned topic Compare dates in RPM

‏2007-11-19T18:54:08Z |
Hi ,

I want to design a report in RPM (7.1) which compares the dates and produce the difference.I am trying to use DATEOF() function , but it is throwing some error.Pls let me know how to do it.

Thanks,
Crano
Updated on 2010-07-15T22:51:00Z at 2010-07-15T22:51:00Z by Duckster
  • SystemAdmin
    SystemAdmin
    1569 Posts
    ACCEPTED ANSWER

    Re: Compare dates in RPM

    ‏2007-11-21T08:56:38Z  in response to sobha
    Hi,

    Are you using the in-build report writer? If so, is it DATEOF() or DAYOF()?

    There may be some errors with date format. What is the date format You are using. What are Your regional settings? Try changing the date format in to English and let us know if the problem is still there.

    Regards

    Piotr

    Message was edited by: czajkowski
    Updated on 2007-11-21T08:56:38Z at 2007-11-21T08:56:38Z by SystemAdmin
    • sobha
      sobha
      13 Posts
      ACCEPTED ANSWER

      Re: Compare dates in RPM

      ‏2007-11-23T09:55:14Z  in response to SystemAdmin
      Hi ,

      The issue is solved by converting the variable to DATE type.

      Thanks
      • Duckster
        Duckster
        1 Post
        ACCEPTED ANSWER

        Re: Compare dates in RPM

        ‏2010-07-15T22:51:00Z  in response to sobha
        Hi could you explain exactly how to do the date conversion?