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

Nuno Sousa

on 10/2/19, 8:51 AM • 1,796 views

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

Reply
Comment
Share

Carlos Nogueira

On 10/2/19, 4:22 PM

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.

Comment
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: 10/2/19, 8:51 AM
Seen: 1796 times
Last updated: 10/15/19, 10:31 AM