Last month filter button

Ask the community
,
1

Hello everyone,
How do I create a button that filters a dataset to show only items from the last month.

Thank you.

2

Eny help please

3

You can do something like this:


import wixData from 'wix-data';

$w("#myButton").onClick( (event) => {
    let first = < first day of last month >;
    let last = < last day of last month >;

    $w("#myDataset").setFilter( wixData.filter()
        .ge("date-field", first)
        .le("date-field", last)
    )
    .then( () => {
        console.log("Dataset is now filtered");
    } )
    .catch( (err) => {
        console.log(err);
    } );
} );

This should get you going in the right direction.

1 Like
4

will it work with the week and the year in the same way?

5

@oussamaismaili7 You just need to set first and last variables to the correct dates.

1 Like
6

Thank you so much @yisrael-wix

1 Like
7

@yisrael-wix
Do you know a way to get last year’s date based on today’s current date.

8

let yearValue = (localDate.getFullYear() - 1 ) ;

9

@oussamaismaili7 I did a search for javascript get date year ago and I got lots of results. One good one is: How to determine one year from now in Javascript

Good luck.