VBA Conditional Calling Based on Current Date

[default_name]

Hello,

I have a few different functions that are set up to do different things depending on the current date.

List of functions:
2020_Tasks
2021_Tasks
2022_Tasks

Is there a way, using VBA, to only call the '2020_Tasks' function if the current year is 2020, and then to continue moving through the rest of the sub.
(similarly only calling '2021_Tasks' if the current year is 2021, etc...)

Thanks in advance

 

[Norie]

What are the actual names of the functions/subs?

 

[default_name]

Here's an idea of what I'm lookng to do....i know that the syntax is not correct, but hopefully it gives an idea
I realized that I had the function names backwards in my original post. Apologies.

Sub UpdateData()

' Some sort of conditional statement that establishes this year
    If now = 2020 Then
         Call Tasks_2020  'only call this function if it is being called during the year 2020
    Else If now = 2021 Then
         Call Tasks_2021  'only call this function if it is being called during the year 2021
    Else
         Call Tasks_2022  'only call this function if it is being called during the year 2022
    End If

End Sub

 

[Fluff]

How about

   Select Case Year(Date)
      Case 2020
         call 2020_Tasks
      Case 2021
         call 2021_tasks
      Case 2022
         call 2022_Tasks
   End Select

 

[default_name]

How about

   Select Case Year(Date)
      Case 2020
         call 2020_Tasks
      Case 2021
         call 2021_tasks
      Case 2022
         call 2022_Tasks
   End Select

Wow that was quick.
Does the Year(Date) require any additional coding (defining the current date, year, etc)? Is it really that simple?

 

[Fluff]

Nothing else needed, date returns the current date & Year then returns the year for that date.