You are viewing limited content. For full access, please sign in.

Question

Question

Workflow strips time values when setting Forms BP variables for DateTime fields

Forms Workflow
Updated June 21, 2018
asked on June 6, 2018

I'm using the 'Set Business Process Variables' activity in Workflow to set the value of a date field in Forms. The date field has the 'show time' option enabled.

However, whenever I set the value, the time is stripped and only the date is entered.

Workflow:

Resulting form:

What happened to the time value? Is this a limitation of Workflow, or Forms?

(I went into the bp_data table, looked at manually populated dueDate fields and confirmed that I'm using the correct format for that field type.)

--

Versions: Forms 10.3.1 Update 1, Workflow 10.2

0 0

Replies

replied on June 6, 2018

What is the date format on the Workflow and Forms servers? Is the token tagged as datetime?

0 0
View 10 previous replies
replied on June 6, 2018

What do you mean by "date format on the Workflow and Forms servers"?

This is a VM so everything is on the same machine.

Token tag in WF is set to DateTime.

0 0
replied on June 6, 2018

I mean the Windows date format for the service user in Workflow and Forms. Your value does not seem to match standard (US) date formats for Windows.

0 0
replied on June 6, 2018

I formatted the value based on existing (manually entered) values for that field in the cf_bp_data table in Forms:

Windows date & time settings for the user show the following:

0 0
replied on June 6, 2018 • Show version history

It looks like the front-end submits the date-time as three separate values (which are then combined by Forms backend before being stored in the database)

Unfortunately, this doesn't tell me anything about what format to use in the 'Set Business Process Variables' activity.

0 0
replied on June 6, 2018

I'm not seeing it. A token tagged as datetime with a value of "2018-06-09 18:30:00" gave me this in Forms:

So it's probably best that you go through Tech Support so the Forms team can look at your process.

0 0
replied on June 6, 2018

Thanks Miruna, I'll open a case.

0 0
replied on June 20, 2018 • Show version history

Just an FYI, I'm seeing the same behavior when I use Workflow's global DateTime token.

If I set the form date/time variable =%(DateTime) in Forms 10.3.1, I get the date but no time.

Workflow lists a datetime token value of 6/19/2018 10:04:26 PM, but the Forms instance data only shows the date portion.

0 0
replied on June 20, 2018

Can you check the Forms database for the value? It should be in the cf_bp_data indexed by submission ID.

0 0
replied on June 20, 2018

It only shows the date in the cf_bp_data table as well.

0 0
replied on June 20, 2018

Hm. Is this a new workflow? Could you try refreshing the field list for the Set Variables activity and republishing it?

0 0
replied on June 20, 2018 • Show version history

Yes, I built/published it yesterday.

I just tried the following and refreshed the variables each time I republished it, but no change in behavior so far.

  • Created a "DateReceived" token with the "DateTime" tag and set it equal to the global %(DateTime) token both with and without formatting
  • Manually entered the date information for "DateReceived" so it does not appear to be isolated to the %(DateTime) token.

 

Just to be thorough I also tried with Read Only disabled for that field, but that didn't seem to make a difference either.

I did notice that in Workflow the "type" for the date/time in Workflow is showing up as "Date" in our production and test Workflow/Forms environments.

I'm guessing it should appear as a DateTime when the time is included in the form field?

0 0
replied on June 20, 2018

And your Workflow Server is version 10.2.0.216?

1 0
replied on June 21, 2018 • Show version history

That was it! I just applied Hotfix 1013837 to our test environment Workflow server and after that it correctly updated both the date and time in Forms.

Thanks for the help!

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...