Forum Discussion
Convert Column from Date to Text with Date Format only IF Cell contains "something"
Hello everyone, If anyone knows how to do this I'd be very grateful. Since I am using Power Automate and it doesn't read values from cells/rows/columns in Date format I am manually converting a...
I'd do that on Power Automate site, something like
=formatDateTime(addDays('1900-01-01T00:00:00Z', int(item()?['MyDate'])), 'yyyy-MM-dd')