Conditional Append

[shaunwilks]

I dont want to append a query until a certain point in time this year.

I'd like the append in the advanced script to have a conditon only to append if the current date and time was greater than a date I specify.

I have dozens of queries to append and all relate to specific dates. I dont wish to have to come in and do each of the manually across the year.  So how would I get the following to only append after June 1st 2022 ?

#"Appended Query" = Table.Combine({#"Table2", #"Table1"})

Thanks in advance

[Vijay_A_Verma]

I would like to see your date column. Will your date column contain all dates as 1-Jun-22 or say 1-Jan-22 to 31-Dec-22 and we need to merge only those rows where if today>date specified by you say 1-Mar-22.

[shaunwilks]

There is no date column in the tables. The date I am talking about is the system/coimputer date 

I want to append a query after 01/03/2022

I want to append another query after 01/04/2022

I want to append a third query after 01/05/2022

etc etc etc etc 

These are web queries where I know the webpages will be populated in the manner I need them too after those dates.

At the moment the queries dont have the data I want so I cannot append them now.

Rather than have to get into the solution every month I want to schedule the appends and let the online Scheduled Refresh append the queries on the schedule that I set out.