General

Re: Convert time to text? Date too?

shniggens — Thu, 05 Jan 2012 16:40:43 GMT

Would that work on a drop-down list box?

If I am concatting the date and time into another field in a repeating table (which is where I applied your formula), and then lookup the concatted field in a drop-down list box, where should I apply the FormatDate?

Re: Convert time to text? Date too?

Jimmy — Thu, 05 Jan 2012 16:15:27 GMT

Well, the qRules FormatDate command should be able to accomplish that for you, without all this fancy XPath.

Re: Convert time to text? Date too?

shniggens — Thu, 05 Jan 2012 15:50:52 GMT

Great, got it, thanks!

Now, to convert the date text from 05/01/2012 to Wednesday, May 01, 2012. ; )

Re: Convert time to text? Date too?

Jimmy — Thu, 05 Jan 2012 15:46:07 GMT

This should work for that:

concat(substring(field1, 6, 2), "/", substring(field1, 9, 2), "/", substring(field1, 1, 4), " ", substring("0", 1, substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0) < 10), substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0), substring(field2, 3, 3), " ", substring("AP", 1 + (substring(field2, 1, 2) >= 12), 1), "M")

Note the underlined 3 there. That's the only part that changed.

Re: Convert time to text? Date too?

shniggens — Thu, 05 Jan 2012 15:35:22 GMT

This formula from Jimmy worked -

concat(substring(field1, 6, 2), "/", substring(field1, 9, 2), "/", substring(field1, 1, 4), " ", substring("0", 1, substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0) < 10), substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0), substring(field2, 3, 6), " ", substring("AP", 1 + (substring(field2, 1, 2) >= 12), 1), "M")

Where field one is my date field and field two is my time field. Now I just need to remove the seconds from the time.

Re: Convert time to text? Date too?

Jo-Anne Alfafara — Thu, 05 Jan 2012 02:29:26 GMT

Hi,

Is this post similar to what your doing? Jimmy posted some good suggestions.

Convert time to text? Date too?

shniggens — Wed, 04 Jan 2012 22:25:39 GMT

I need to get the text value of a formatted time and date, so that I can concat them in a field to later be available in a drop-down list. I have 2 seperate fields, one for date, one for time. I was able to successfully convert the date into another field into a mm/dd/yyyy format. That's good enough. But I'm only able to get a 24 hour format out of the time.

Suggestions?