How to format from date only year and store in other entity by excel import by parse microflow

0
Hi all, I am trying to insert data in year-entity from “excel importer”  from realistic-entity of date-attribute, but date attribute is of type “12-01-2022” (Date and Time) and I want store only 2022 in Year-entity(Year_attribute(integer)) for that I have used “import from excel” for that I am using parse “microflow” so, can some one help me with this.   can someone help me for formatting from date only year and store in other entity please.
asked
1 answers
0

Hi Pranaya D,

We can use a variable to store just the year from the date:

https://docs.mendix.com/refguide/xpath-year-from-datetime/

year-from-dateTime(DateAttribute)
answered