Date difference in day, hour and minutes

[thead]

Hello,

I want to get the age of added record in day, hour and minutes:
If Record is created today then display in hrs & Min ( 1hrs 15min ago)
If Record is created 1 day ago then need to display (1 day ago)

[April]

Hi Thead,

You may try this formula to achieve your desired output:

CASE

WHEN Datediff(hour, [@field:Date], GetUTCDate()) <24 THEN CAST(Datediff(hh, [@field:Date], GetDate()) % 24 AS varchar) + 'hrs' + CAST(Datediff(mi, [@field:Date], GetDate()) % 60 AS varchar) + 'mins'

ELSE CAST(Datediff(dd, [@field:Date], GetDate()) AS varchar) + 'days' + CAST(Datediff(hh, [@field:Date], GetDate()) % 24 AS varchar) + 'hrs' + CAST(Datediff(mi, [@field:Date], GetDate()) % 60 AS varchar) + 'mins'

END

 

Hope this helps.

[April]

You may also check this link for different format:

 

[PotatoMato]

Hi @thead, you can also check the how-to article regarding date/time functions: https://howto.caspio.com/function-reference/#:~:text=Date and Time Functions

[Flowers4Algernon]

Hello! May this forum post may be helpful: