topic RE: Create timestamp including milliseconds in Product Forum

Create timestamp including milliseconds

Roberto_LuisRod — Wed, 02 Dec 2020 17:15:00 GMT

Hello!
I am trying to create a timestamp including milliseconds with the following expression:
FormatDateTime(Now(), "yyyy_MM_dd_hh_mm_ss_fff")
According to the Dot.Net documentation (https://docs.microsoft.com/de-de/dotnet/standard/base-types/custom-date-and-time-format-strings) it should work with fff. Unfortunately I only get 000 at the end, which is unlikely to be correct considering the number of attempts I already made.
What should the format string be so that the milliseconds are part of the result?
PS: FFF instead of fff does not work either.
Thanks a lot!
#BPTechTips

------------------------------
Roberto Luis Rodríguez Estévez
Senior Software Developer
Expleo Technology Germany GmbH
Europe/Berlin
------------------------------

RE: Create timestamp including milliseconds

NileshJadhavBP — Wed, 02 Dec 2020 20:18:00 GMT

Hi Roberto,

Please do below things

1.add namespace and dll in initial stage

Namespace:: Microsoft.VisualBasic

Assembly:: Microsoft.VisualBasic.Core.dll

2.Please use code stage with below code (MS will be string as output)

Dim MS
MS = format(Now,"yyyy_MM_dd_hh_mm_ss_fff")

You can build code here without installing .net (https://www.tutorialspoint.com/compile_vb.net_online.php)

I hope your issue is resolve now.

thanks

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------

RE: Create timestamp including milliseconds

ewilson — Wed, 02 Dec 2020 22:03:00 GMT

This works for me:

DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss_fff");

Here's a screenshot of returning that in an output data item (of type Text) in a code stage:

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Create timestamp including milliseconds

Roberto_LuisRod — Thu, 03 Dec 2020 08:45:00 GMT

Thanks to @ewilson and @Nilesh Jadhav: Your both did it! Now it works fine. Thanks!

Remark: @Nilesh Jadhav: I ommit the (re) definition of MS because MS is already defined as output.

------------------------------
Roberto Luis Rodríguez Estévez
Senior Software Developer
Expleo Technology Germany GmbH
Europe/Berlin
------------------------------

RE: Create timestamp including milliseconds

NileshJadhavBP — Thu, 03 Dec 2020 11:14:00 GMT

Hi @Roberto Luis

its great news and really happy as you got output 🙂

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------