Skip to main content
Answer

Issue filtering by @today

  • August 8, 2023
  • 6 replies
  • 307 views
xkylewrightx
Varsity III
Forum|alt.badge.img

Hi-

We have tons of sales orders created today (8/8/23):

 

When I filter by ‘Created On’ equals 08/08/2023 I get the proper records:

I also get the proper results when clicking ‘Today’ under the filter:

 

However, I get zero results when filtering by Created On = @Today

 

This filter is required in order to make a dashboard (same results can be seen by making a dashboard widget with the @today filter). Does anyone know why @Today does not aggregate results that pertain to todays date? Is there a change that needs to be made to the column in the GI setup?

 

Appreciate any help!!

Best answer by darylbowman

I’m guessing this is because the first two methods you mentioned do not take time of day into account. If I’m not mistaken, @Today on this very date would equal 8/8/2023 12:00 AM. If you use this value in an equals comparison, no records will match because none were created at 12:00 AM.

You can, however, use the is between comparison with value 1 being @Today and value 2 being @Today + 1 (tomorrow at 12:00 AM)

Kyle Wright CSW, Inc. | www.cswgraphics.com

    6 replies

    xkylewrightx
    Varsity III
    Forum|alt.badge.img
    • xkylewrightx
    • Author
    • Varsity III
    • August 8, 2023

    Edit: 

    Workaround I found ‘Today’ under the ‘Conditions’ column on the Dashboard widget.

    ‘Today’ is a value, not a condition, so this does not make any sense why it is here:

     

    Kyle Wright CSW, Inc. | www.cswgraphics.com
    darylbowman
    Captain II
    Forum|alt.badge.img+15
    • darylbowman
    • Answer
    • August 8, 2023

    I’m guessing this is because the first two methods you mentioned do not take time of day into account. If I’m not mistaken, @Today on this very date would equal 8/8/2023 12:00 AM. If you use this value in an equals comparison, no records will match because none were created at 12:00 AM.

    You can, however, use the is between comparison with value 1 being @Today and value 2 being @Today + 1 (tomorrow at 12:00 AM)

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    P
    B
    S
    Semi-Pro III
    Forum|alt.badge.img+9
    • sweta68
    • Semi-Pro III
    • August 9, 2023

    Hi @xkylewrightx ,

     

    You can refer to the screenshot below to set the value for today's date.

    It will accurately filter out the date for today.

     

    Regards,

    Sweat

    Chris Hackett
    xkylewrightx
    Varsity III
    Forum|alt.badge.img
    • xkylewrightx
    • Author
    • Varsity III
    • August 10, 2023

    @darylbowman 

    I believe this is the correct explanation, however @today → @today-1 still does not match any records.

    The problem with using condition Today in the dashboard, as below, is that the drilldown does not work because this is not valid in the GI.

    Still not seeing a valid way to create this filter

     

     

    Kyle Wright CSW, Inc. | www.cswgraphics.com
    darylbowman
    Captain II
    Forum|alt.badge.img+15

     Are you saying you tried exactly what is below and it’s not working?

    I wouldn’t expect ‘is between @Today  |  @Today-1’ to work because I’m guessing it’s expecting value 2 to be greater than value 1. Additionally, even if this did work, it would display records from yesterday, which isn’t what you asked for above.

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    xkylewrightx
    Varsity III
    Forum|alt.badge.img
    • xkylewrightx
    • Author
    • Varsity III
    • August 10, 2023

    @darylbowman Whoops typo @today → @today+1 works. Appreciate the help. 

    Kyle Wright CSW, Inc. | www.cswgraphics.com
    darylbowman
    Chris Hackett
    Robert Sternberg
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved