Skip to Content
author's profile photo Former Member
Former Member

New Year report date issue

We have a report that has been fine.Now since 2014 was just told that the report is not showing past 'Open Orders' only since Jan 1 2014.

In the report select I see this date formula:

but seems to me it should be showing past 180 days ?

{CROPNORD.ORDER_DATE} > ((DAY(CurrentDate)+MONTH(CurrentDate)*100 + YEAR(CurrentDate)*10000) - 180)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 07, 2014 at 01:19 AM

    hey Paul,

    i'm assuming that you do want the past 180 days, i.e. since july 10, 2013 correct? if so, the second part of the formula seems to be the issue...i'm assuming that the order date is in the format yyyyMMdd and if so, try using the following instead...

    {CROPNORD.ORDER_DATE} > tonumber(totext((currentdate - 180),'yyyyMMdd'))

    the second part of that formula currently returns 20139926 instead of 20130710. if the order date is in a different format than above, please let us know how that date is derived.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.