Now() formats varies

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-06-17 03:34 PM
Hello,
I have a minor problem using Now() function.
Please check the attachment.
I have a calc which does: Now() + MakeTimeSpan(0; 3; 0; 0) and saves the value to [DateTime] dataitem.
Next calc: Replace([DateTime]; "/"; ".") and converts datetime to text.
Sometimet Now() returns datetime in different formats as in picture. I want to get always format: 12.06.17 17:35:42. At the moment the format varies from GB standards to Finnish standards. Do you know why this happens and how it's fixed?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-06-17 01:06 AM
You could use FormatDateTime function ..FormatDateTime (Date, DateFormat);
Examples
FormatDate(""02-11-2016 09:23:43"", ""t"") will return ""09:23""
FormatDate(""02 Nov 2016 09:23:43"",""F"") will return ""02 November 2016 09:23:43""
FormatDate(""02-11-2016 21:23:43"", ""h:m tt"") will return ""9:23 PM""
FormatDate(""02-11-2016 21:23:43"", ""dd/MM/yy HH:m:s"") will return ""02/11/16 21:23:43
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-02-18 04:49 PM
Hi,
How many digits we can include for miliseconds in FormatDate ? I am putting ""dd/MM/yy HH:mm:ss.mmm"" but it is giving me two digits only for the miliseconds.
Could you please confirm how many digits blueprism returns in miliseconds ?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-18 09:36 PM
We have the same issue
