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

Question

Question

Date Format yyyymmdd to mm/dd/yyyy

Workflow Version 9
Updated September 15, 2016
asked on September 15, 2016 • Show version history

Hello,

I am pulling a date from a DB query and the date comes back as yyyymmdd (20160915) I'm trying to convert it to a format LF designer will read/understand for a data metadata field.

0 0

Replies

replied on September 15, 2016

Hi Darren.

Did you try to do the following?



After do te cast use token editor in laserfiche for the format that you need.




That maybe can work for you otherwise you can try give it the format directly on sql



Hope can work for you

Regards.

1 0
replied on September 15, 2016

David,

I was using the Query Data activity in LF Designer to get the date from one of our operational systems and didn't know how to do the cast you were referring to.

I did manage to solve my issue through 'Date Token Calculator' and regular expressions:

Thanks for your help.

Darren

1 0
replied on September 15, 2016

Hi Darren Glad to hear about that.

Exactly I was thinking in put a Custom query node with a query on it 

Like this 



And then




Just 2 steps.

Regards 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...