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

Por

Nuno Sousa

on 02/10/19, 08:51 • 1691 visualizações

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.

Flag

Responder
Comentário
Partilhar

Carlos Nogueira

Ligar 02/10/19, 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.

Comentário
Flag

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/19, 08:51
Seen: 1691 times
Last updated: 15/10/19, 10:31