Change colons to periods in date/time field

Avatar

Avatar

tracik18452726

Avatar

tracik18452726

tracik18452726

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 (0)

Answers (2)

Answers (2)

Avatar

Avatar

Kosta_Prokopiu1

Employee

Avatar

Kosta_Prokopiu1

Employee

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

 

 

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

07-04-2021

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