I am going to take a quick guess at possible directions you want to go:

You have a lot of objects with a date set to 1^st of October and you want to set them to 30^th of September

If you want to do this, what you might want to use is a function to set the dates:

• create a microflow that retrieves all these objects (with date of 1^st of October)
• Create a list of the entity (named “EntityList_ToCommit”)
• Iterate over these objects and do one of 2 things
  • Change the date to 30^th of september
    • https://docs.mendix.com/refguide/parse-and-format-date-function-calls#parsedatetime-utc
  • Change the date by removing 1 day and trimming the date to the begin of the day
    • https://docs.mendix.com/refguide/add-date-function-calls#6-adddays-utc
    • https://docs.mendix.com/refguide/trim-to-date
• add the changed objects to the List ToCommit
• Commit the changed objects outside of the iterator.

Hi Ravi,

You need to do this. In a microflow, retrieve the dates:

Inside a loop check,

if    month-from-dateTime(DateAttribute) >=10  , change the list set the financial year =year-from-dateTime(DateAttribute)

else  financial year =year-from-dateTime(DateAttribute)-1