As of Dates Data Block

The As of Date (AsofDates) Data Block may be edited, though it is not required to edited in order for Assette to function.

The As of Date (AsofDates) Data Block is an Assette System Data Block that will return the previous 24 month ends, if a client wants to derive the As of Dates from an external data source, they will need to make the necessary changes to the Data Block, otherwise no changes to the As of Date (AsofDates) System Data Block or any dependencies.

General Info #

Field	Value
Name	AsofDates
Block Category	Interface
Block Type	Python
Data Category	None
Output Type	Data Table

Dependencies #

Data Block Name	Description
PythonEnvForDateCalculation	Defines the imported Python modules and libraries (e.g., “import numpy as np”)
AsOfDatesLocalDB	The As of Dates Local Database (AsOfDatesLocalDB) is used as a dependency by other Data Blocks and is designed to retrieves available As of Dates from Assette for legacy clients. This Data Block should not be edited. [Link]
GetClientConfigLocalDB	Returns the current configurations from Assette [Link]

Example Definition #

# Input Parameters
#       {
#           "Action": (string)action, [Ex: "Generate"]
#       } 

nmonths = 24 # Number of months to go back
datelist = []
Output = []
Action = "Generate"
if(params.__len__()>0):
    Action = params["Action"]
    if "nmonths" in params:
        nmonths = abs(int(params["nmonths"]))

interface_method = "Local"
#interface_method=read("GetClientConfigLocalDB", {"ParamName":"InterfaceMethod"})["data"][0]["ParamValue"]
interface_df = pd.DataFrame(read("GetClientConfigLocalDB",{"ParamName":"InterfaceMethod"})["data"])

if interface_df.empty:
    interface_method="Local"
else:
    interface_method=interface_df.iloc[0]["ParamValue"]
    #interface_method=interface_df["ParamValue"]

if interface_method == "BYOD":
    """
    sample param values:{
        "nmonths": 24
    }
    """
    nmonths = 24 # Number of months to go back
    datelist = []
    Output = []

    if "nmonths" in params:
        nmonths = abs(int(params["nmonths"]))

    current_date = datetime.datetime.now()
    datelist = []
    Output = []

    # Include the current month-end date if current_date is a month-end
    current_month_end = current_date.replace(day=calendar.monthrange(current_date.year, current_date.month)[1])
    if current_date == current_month_end:
        datelist.append(current_date)

    # Append month-end dates for the previous months
    for months in range(0, nmonths):
        last_month_end = current_date.replace(day=1) - datetime.timedelta(days=1)
        datelist.append(last_month_end)
        current_date = last_month_end

    datelist.sort(reverse=True)  # Sorting the dates in descending order

    idx = len(datelist)  # Initialize the index

    for date in datelist:
        smon = "0" + str(date.month) if len(str(date.month)) == 1 else str(date.month)
        sday = "0" + str(date.day) if len(str(date.day)) == 1 else str(date.day)
        Output.append({"ID": idx, "AsOfDates": smon + "/" + sday + "/" + str(date.year)})
        idx -= 1  # decrement the index    
else:
    Output = read("AsOfDatesLocalDB",{"Action":str(Action)})["data"]
    
response["data"] = Output

#

Example Request #

The As of Date System Data Block will return the previous 24 month ends, if a client wants to derive the As of Dates from an external data source, they will need to make the necessary changes to the Data Block

{}

Example Response #

{
    "data": [
        {
            "ID": 24,
            "AsOfDates": "06/30/2024"
        },
        {
            "ID": 23,
            "AsOfDates": "05/31/2024"
        },
        {
            "ID": 22,
            "AsOfDates": "04/30/2024"
        },
        {
            "ID": 21,
            "AsOfDates": "03/31/2024"
        },
        {
            "ID": 20,
            "AsOfDates": "02/29/2024"
        },
        {
            "ID": 19,
            "AsOfDates": "01/31/2024"
        },
        {
            "ID": 18,
            "AsOfDates": "12/31/2023"
        },
        {
            "ID": 17,
            "AsOfDates": "11/30/2023"
        },
        {
            "ID": 16,
            "AsOfDates": "10/31/2023"
        },
        {
            "ID": 15,
            "AsOfDates": "09/30/2023"
        },
        {
            "ID": 14,
            "AsOfDates": "08/31/2023"
        },
        {
            "ID": 13,
            "AsOfDates": "07/31/2023"
        },
        {
            "ID": 12,
            "AsOfDates": "06/30/2023"
        },
        {
            "ID": 11,
            "AsOfDates": "05/31/2023"
        },
        {
            "ID": 10,
            "AsOfDates": "04/30/2023"
        },
        {
            "ID": 9,
            "AsOfDates": "03/31/2023"
        },
        {
            "ID": 8,
            "AsOfDates": "02/28/2023"
        },
        {
            "ID": 7,
            "AsOfDates": "01/31/2023"
        },
        {
            "ID": 6,
            "AsOfDates": "12/31/2022"
        },
        {
            "ID": 5,
            "AsOfDates": "11/30/2022"
        },
        {
            "ID": 4,
            "AsOfDates": "10/31/2022"
        },
        {
            "ID": 3,
            "AsOfDates": "09/30/2022"
        },
        {
            "ID": 2,
            "AsOfDates": "08/31/2022"
        },
        {
            "ID": 1,
            "AsOfDates": "07/31/2022"
        }
    ],
    "errors": [],
    "success": true,
    "logs": []
}