Hello,
I have a list with multiple columns and a calculated column . This column (Column Name-Data nasterii ) calculate automate birthday based on Card ID stored in other column. This calculated column is date formatted. After an item is created in this list i copy this item to another list using flow. The calculated column is copied in the new list but always display the Birthday date minus 1. I don't know why and try to figure out a solution. Also in the history of the workflow this date is one day minus the displayed date on the list.
I attached some screenshots , maybe someone will explain what's happen and how can i resolve this issue.
Thank you
Calculated Column Bitrhday
Value in Flow History
Value of calculated Birthday in orginal list
Value in Copy list
@ciprianpopovici When you create calculated column of date type it always subtract default time of that region that is why you are seeing one day less in your list. Add minutes/hours in your flow logic. Example- Region GMT+5:30 This will give me calculated column date with time like 2021-09-22T18:30:00Z so i always add 330 mins to make it equal.
Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.