Turn datetime into a string

[katlego_lionel]

Hi Guys,

Is there a way to turn datetime to string?

e.g. “Posted 2 days ago”

Please see attached for reference.

[Suvrutt_Gurjar]

Please try something like below in a text type column

CONCATENATE ("Posted ", "
“,TEXT( HOUR(TODAY()-DATE([DateTime]))/24), " days ago”)

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

help.appsheet.com

CONCATENATE()

Merged text from parts

help.appsheet.com

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.

[katlego_lionel]

Thank you so much, Suvrutt.

It worked great.

Could you also assist with an IF expression to show the time (min & hours) of post if it has not been over 24Hrs yet.

e.g. “Posted 5 min ago” or “Posted 1 hour ago”

Look forward to your answer.

Regards

[Suvrutt_Gurjar]

I think such granularity may not work well in AppSheet app. This is so because unless the user syncs the app, the user may not see something as granular as posted 5 minutes ago.

AppSheet automatic updates take place at about 30 minutes intervals. So please evaluate your requirement in that context.

Also could you please try forming an expression based on the date and time expressions article shared with you? Please feel free to approach the community with your expression if you have any queries in that.

[katlego_lionel]

Thank you once again.

You have been a great help.

[Suvrutt_Gurjar]

You are welcome. Of course if you are okay with workarounds , please take a look at the below tip by @Fabian

Auto Refresh / Automatic Update Tips & Tricks 💡

Under Behavior > Offline/Sync we can enable Automatic updates. [image] If you want to update the App more often, you can install an Auto Refresh Add-On like: [image]