How to stop keep formatting using prepare / formula recipe

abalo006

I have string value called hours, formatted as "00" and a value called minutes formatted as "07".

Im trying to use the concat function to create an HH:mm value = 00:07 but for some reason when using concat, it gets rid of trailing 0s and results in 0:7. is there a way around this?

if not is there any other way I can create my HH:mm value using my hours and minutes values?

---

Operating system used: windows

Turribeach

This formula can add leading zeros as required:

concat(("00" + Hours).substring(-2), ":", ("00" + Minutes).substring(-2))

Turribeach

Concat does not remove any leading (or trailing) zeros, it simply joins strings:

You have a different problem. Post your whole formula.

abalo006

It looks like you're typing in "00" and "07" in quotes in your concat function, it doesn't seem to work the same way when the 00 is a field that you already have. Doing it in quotes works but, in my case, I'm referencing my "minutes" and "hours" fields

Turribeach

What data type are Hours And Minutes and where are they coming from? Have you extract them from a date/time field? If so how?

abalo006

Thanks!

apichery

Alternative (and somewhat simpler) method using the format function (https://doc.dataiku.com/dss/latest/formula/index.html#string-functions)

format("%02d:%02d", Hours, Minutes)