Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
Converting Dates and Times
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.
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.
Keep Informed
About the Community
Question tools
Stats
Asked: 02/10/19, 08:51 |
Seen: 1779 times |
Last updated: 15/10/19, 10:31 |