Date Format

(1) Share

Report

Posted on by HectorOlivos

411

Hello community!

Is there a way to format a date in PowerApps where my date is 4/21/2023 10:19 AM to be changed for example 1 min ago then 4 hours ago then 1 day ago and like that.

The date value is ThisItem.Created from the Default created column in SharePoint.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

NZ0090 317 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @HectorOlivos !

I guess you can do something like this?

If( DateDiff(ThisItem.Created, Now(), TimeUnit.Minutes)<60, DateDiff(ThisItem.Created, Now(), TimeUnit.Minutes) & " minutes ago", DateDiff(ThisItem.Created, Now(), TimeUnit.Minutes)>60 && DateDiff(ThisItem.Created, Now(), TimeUnit.Hours)<24, DateDiff(ThisItem.Created, Now(), TimeUnit.Hours) & " hours ago", DateDiff(ThisItem.Created, Now(), TimeUnit.Days) & " days ago" )

Was this reply helpful? Yes No
HectorOlivos 411 on at

Like
a
(2)

Report
Copy link

Link copied!
Yep that worked, though i found another solution:

If( DateDiff( (ThisItem.Created), Now(), TimeUnit.Minutes ) < 60, Concatenate( Text( DateDiff( (ThisItem.Created), Now(), TimeUnit.Minutes ) ), " mins ago" ), DateDiff( (ThisItem.Created), Now(), TimeUnit.Hours ) <= 24, Concatenate( Text( DateDiff( (ThisItem.Created), Now(), TimeUnit.Hours ) ), " hours ago" ), DateDiff( (ThisItem.Created), Now(), TimeUnit.Days ) <= 31, Concatenate( Text( DateDiff( (ThisItem.Created), Now(), TimeUnit.Days ) ), " days ago" ), DateDiff( (ThisItem.Created), Now(), TimeUnit.Months ) <= 12, Concatenate( Text( DateDiff( (ThisItem.Created), Now(), TimeUnit.Months ) ), " months ago" ), Concatenate( Text( DateDiff( (ThisItem.Created), Now(), TimeUnit.Years ) ), " years ago" ) )

Thanks for the answer!

Was this reply helpful? Yes No