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

SOLVED

Change colons to periods in date/time field

tracik18452726
Level 2
Level 2

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

 

1 Accepted Solution
Kosta_Prokopiu1
Correct answer by
Employee
Employee

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

 

 

View solution in original post

2 Replies
radzmar
Level 10
Level 10

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

Kosta_Prokopiu1
Correct answer by
Employee
Employee

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

 

 

View solution in original post