Getting a DATEDIFF result in M,D format :thread:
# gooddata-uib
Byron Antoniadis
01/24/2025, 7:19 AMGetting a DATEDIFF result in M,D format 🧵
Byron Antoniadis
01/24/2025, 7:20 AMHello team,
We are an HR software and we want to calculate the duration of an active contract. Our clients want to show this duration in months, days, eg:
2m, 23d
4m, 12d
etc.
Byron Antoniadis
01/24/2025, 7:20 AMI have managed to calculate the duration in days or in months, but cannot achieve what I want. Can you help?
m
Michael Ullock
01/24/2025, 10:50 AMHi Bryan, you can customize the format of the numbers - Unit conversion allows you to implement simple arithmetics to format metrics into various display outputs such as duration or length. More details can be found here:
https://www.gooddata.com/docs/cloud/create-metrics/format-numbers/#FormatNumbers-UnitConversioninMetricFormatting
Hope this helps!
m
Mauricio Cabezas
01/27/2025, 1:58 PMHi Byron, we’re just wondering if you've had a chance to review my colleague's latest update. Please let us know if you still need any further assistance.
b
Byron Antoniadis
03/10/2025, 9:19 AMHello - what happens if I just want to format a date in a visualisation without using a metric?