Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automation (Interface Filter)

281 4
cancel
Showing results for 
Search instead for 
Did you mean: 
FPX
6 - Interface Innovator
6 - Interface Innovator

Hi all 

As per my screenshot below, I have a filter for orders with an ETD (estimated time departure) on or before the last day of the current month. On the first day of each month i currently manually update this. 

How can I set up an automation that occurs on the first day of each month that updates 'exact date' to the last day of each month? e.g. 30th sepertember today so 1st October should update filter with exact date to 31st October.

@kuovonne @TheTimeSavingCo - let me know if you guys have any suggestions too please? Thank you!

FPX_0-1727641851026.png

Thank you

4 Replies 4

Perhaps try using formula fields instead to filter off of?  You'd have a formula field that outputs the last day of the current day's month, and another field that checks whether "Date Required" is before that:

Screenshot 2024-09-30 at 10.53.29 AM.png

DATEADD(
  DATEADD(
    DATETIME_PARSE(
      DATETIME_FORMAT(
        TODAY(),
        "MM YYYY"
      ),
      "MM YYYY"
    ),
    1,
    'month'
  ),
  -1,
  'day'
)
{Date Required} <= {Last day of this month}

Thanks that'll work. Strange that there is no drop down field which would allow you to select 'End of Current Month' instead of having to specify what this exact date is

FPX_0-1727665691725.png

 

You can use the condition that the date is within this calendar month to get records for the current month, including up to the end of the current month. To also get dates before the current month, use "or" with the condition that the date is before today.

kuovonne_0-1727669517332.png

In general, I recommend avoiding formula fields that use TODAY() because that formula can be resource intensive.

 

FPX
6 - Interface Innovator
6 - Interface Innovator

My filter does not allow me to use 'Or'? it only allows 'And'?

FPX_0-1727690589256.png