how can I pass 1st of month and last day of month in request body in the export step?

AI generated answer (using internal Slack threads):

To pass the 1st day of the month and the last day of the month in the request body in the export step, you can use the

ADD_MONTHS

and

LAST_DAY

functions in your formula. For the first day of the month, you can use the

ADD_MONTHS

function to add 1 month to the current date and then subtract the day of the month. Here is an example:

code
ADD_MONTHS({currentdate}, 1) - DAY({currentdate})

For the last day of the month, you can use the

LAST_DAY

function. Here is an example:

code
LAST_DAY({currentdate})

You can use these formulas in your condition to filter the data that you want to export. Please note that

{currentdate}

should be replaced with the field that contains the date you are working with. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******