Controls

Re: Field Value Shows Time Stamp

Angie_Fox — Fri, 24 Jan 2014 20:29:43 GMT

Thank you so much. It worked beautifully. Regards,Angie

Re: Field Value Shows Time Stamp

Hilary Stoupa — Fri, 24 Jan 2014 18:27:03 GMT

You can change the field the calendar control is bound to so that the data type is just Date.

Or, if for some reason you need the field to be date time:

concat(FORUM, "-", ACTION TYPE, "-", substring-before(IDENTIFIED, "T"))

Field Value Shows Time Stamp

Angie_Fox — Fri, 24 Jan 2014 18:19:21 GMT

Help!

I am trying to populate an ID field with 3 combined fields.

FORUM, ACTION TYPE and IDENTIFIED being the 3 fields I need to combine.

When it populates the field, it adds the time. I want to remove it. The calendar control is set to use a date with no time and displays it correctly in the actual IDENTIFIED field but when it populates the ID field, it adds it in.

Right now the formula looks like this: concat(FORUM, "-", ACTION TYPE, "-", IDENTIFIED).

It displays like this: SEIPT-BUS-2014-01-21T00:00:00

I need it to look like this: SEIPT-BUS-2014-01-21

Thanks in advance for any and all help anyone can provide.

Regards,

Angie