General

Re: Formula Help: Substring/Translate

richardlpalmer — Thu, 21 May 2009 19:33:58 GMT

That's super helpful. Thank you very much. :)

(Looks like it doesn't install, runs as a stand alone .exe. I think I'll pin it to my Quck Launch.)

Re: Formula Help: Substring/Translate

Hilary Stoupa — Thu, 21 May 2009 18:17:47 GMT

May I suggest a notepad replacement that has parenthetical matching? Notepad 2 (link is to zip) is a great text editor. If you copy a formula into it, and click by a parenthesis, the match highlights in red. Unmatched are highlighted in blue. It can simplify this type of issue for me, at least...

Re: Formula Help: Substring/Translate

richardlpalmer — Thu, 21 May 2009 18:04:02 GMT

Okay, this is the 2nd thread I've started only to find my own problem. I apologize for those of you trying to help only to have me figure out my own bone-headed mistake.

The problem with the formula is an additional end parenthesis after the "T".

So this;

substring-after(translate(@ows_NextReleaseDate[@ows_OfferingID = Offering_x0020_ID], " ", "T")),"#")

Should be this;

substring-after(translate(@ows_NextReleaseDate[@ows_OfferingID = Offering_x0020_ID], " ", "T"),"#")

Problem solved and the date(s) are now displaying perfectly.

Formula Help: Substring/Translate

richardlpalmer — Thu, 21 May 2009 17:56:54 GMT

I have an existing form that I'm modifying due to some internal business process changes. One of the fields displays a filtered date which uses the "translate" function. It essentially displays the date minus the "T" and h:m:s after it.

translate(@ows_NextReleaseDate[@ows_OfferingID = Offering_x0020_ID], " ", "T")

The column that will now be providing the date is from a calculated field. This is what a date looks like: datetime;#2009-07-01 00:00:00

What I've attempted to do is use the "substring-after" function to get rid of the "datetime:#" portion, while leaving the translate function to get an accurate date.

substring-after(translate(@ows_NextReleaseDate[@ows_OfferingID = Offering_x0020_ID], " ", "T")),"#")

I keep getting an error... :(

Any help on sorting it out?