Seconds on Date/Time Submission

[Justin2]

Hello!

I use knack for logging at events with multiple people entering different logs. On submission of a log entry we record the Date/Time Logged, User making the Log and the Log Entry. Is there anyway to show the time as hh:mm:ss and not just hh:mm?

Thanks!

[CarlHolmes]

Hi @Justin2 - Welcome to the community

I’ve had a play around with this challenge but as Knack doesn’t allow for capturing seconds I can’t obtain a result, even using formatDateusing a Text Formula.

Hopefully someone else may have a solution

[Dean2]

Hi

Could you possibly use the Time field type to capture this information?

Dean

[Erik]

If you are a KTL user the _ts (time stamp ) keyword goes down to milliseconds.
I’m sure @CarlHolmes or @NormandDefayette_CortexRD can link you to the instructions.

[CarlHolmes]

You can read more about the KTL keyword _ts on Github

I’ve done a few videos about KTL

Setting up the Configurator

Visit my channel - over 100 Knack tutorials