Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Convert SignedDate to String

Avatar

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Aditya_S_
Level 4

09-12-2010

How is it possible to convert the Signed Time from the PDFSignatureVerificationResult field to String, in workbench? When I assign the value to a string variable I get the zulu time.

Below is the example..

SignedTime = Thu Dec 09 15:52:48 EST 2010

String Value = 2010-12-09T20:52:48Z

Aditya

Accepted Solutions (0)

Answers (6)

Answers (6)

Avatar

Avatar
Level 1
Fisher1
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Fisher1
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
Fisher1
Level 1

05-04-2020

Agnieszka Fisher 

Avatar

Avatar
Level 1
Fisher1
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Fisher1
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
Fisher1
Level 1

05-04-2020

Agnieszka Fisher 

Avatar

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Aditya_S_
Level 4

10-12-2010

Maybe you can help me..... I am unable to get it to work. Have you used it before? Can you send me an example of how the parameters are used?

Aditya

Avatar

Avatar
Validate 1
Level 1
stormshark
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
stormshark
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
stormshark
Level 1

10-12-2010

Hİ my friend I got it now .

there is also date time format command which allows you to change datetime as you desired.

Avatar

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 4
Aditya_S_
Level 4

Like

1 like

Total Posts

315 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
Aditya_S_
Level 4

10-12-2010

Substring doesn't seem to generate any value...

My intention is to insert the value in a database using a custom script. All this while, I have inserted the date as a string. However, converting this to a string gives me the zulu value.

Aditya

Avatar

Avatar
Validate 1
Level 1
stormshark
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
stormshark
Level 1

Likes

0 likes

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
stormshark
Level 1

10-12-2010

Hi . You can use substring and concatenate functions to achieve your goal.

For example

a=substring(SignedTime, 24, 4) Result= 2010

b=substring(SignedTime, 20, 4) Result=EST

and then use concatenate for 

concat(a,"-",b,"-") result 2010-EST-