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

Change colons to periods in date/time field

Avatar

Avatar
Validate 1
Level 1
tracik18452726
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
tracik18452726
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

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

02-04-2021

I am trying to change colons to periods in time in a date/time field. Instead of 12:22:36 I need it to be 12.22.36. I have tried everything I can think of- I can do it when it is just a time field. I tried concatenating a date field with the correctly formatted time field and it reverts back to colons in the concatenated field. Any help would be greatly appreciated- we are trying to save the file with a date and time stamp and Windows does not accept colons in file names. This is an example of the issue I am having:

tracik18452726_0-1617415830324.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
Employee
Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

369 posts

Correct Reply

107 solutions
Top badges earned
Affirm 100
Validate 1
Establish
Give Back 5
Give Back 3
View profile

Avatar
Affirm 100
Employee
Kosta_Prokopiu1
Employee

Likes

165 likes

Total Posts

369 posts

Correct Reply

107 solutions
Top badges earned
Affirm 100
Validate 1
Establish
Give Back 5
Give Back 3
View profile
Kosta_Prokopiu1
Employee

09-04-2021

here is how it works for me:

Kosta_Prokopiu1_0-1617952992941.png

The following is set as patterns for the time field:

Kosta_Prokopiu1_1-1617953061485.png

Use the pattern time{HH.MM.SS} for Display option and if it is interactive also use in Edit.

Then set the calculate script of the text field as follows:

Javascript: DateField1.formattedValue + " " + TimeField1.formattedValue

That gets me this result:

Kosta_Prokopiu1_2-1617953522835.png

 

 

Answers (1)

Answers (1)

Avatar

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct Reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
radzmar
MVP

07-04-2021

What method or script do you currently use to fill the Save File As-field?