Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

Hide Intro Register

Converting Dates and Times

Formula

Par

Nuno Sousa

sur 02/10/2019 08:51 • 1 711 Vues

Hello.

I've been trying to convert a date and a time field to string because I need to concatenate them with another string.

However, I've not found any formulas that allow me to do so, at least directly. I've also tried to turn them into numeric (and then from numeric to string), but had no success.

Any help would be appreciated.

Thanks in advance.

Signaler

Répondre
Commentaires
Partager

Carlos Nogueira

Activé 02/10/2019 16:22

Hi,

There's no formula that directly does that, since date formatting and conversion has a lot of variants (language, precision, order, etc) but you can compose the string as you like. Example:

NumericToString(Year([TABLE->FIELD]),4) + "/" +
NumericToString(Month([TABLE->FIELD]),2) + "/" +
NumericToString(Day([TABLE->FIELD]),2)

Adjust this to your requirements.

Commentaires
Signaler

Ask a Question

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

10 follower(s)

Stats

Asked: 02/10/2019 08:51
Seen: 1711 times
Last updated: 15/10/2019 10:31