web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Convert ticks value ba...

Power Automate - Building Flows

Answered

Convert ticks value back to date string

(0) Share

Report

Report

Posted on by gjayn84

103

Hi everyone

I have a flow that checks three dates in a SharePoint list to see which date is earliest. I've done this by converting the dates into ticks, adding them to an array variable and then using the min() function to find the earliest date.

This works fine but now I want to convert the ticks value back to a date string. I can't find a way of doing this and was wondering if anyone else has a formula/function that can be used to convert ticks to a date?

Thanks in advance.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

abm abm 32,600 Most Valuable Professional on at

Like (1)

Report

Re: Convert ticks value back to date string

Hi @gjayne1984

Check this community post by @Pstork1

Solved: Converting Ticks back to Date - Power Platform Community (microsoft.com)

Thanks

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans