<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic You could use FormatDateTime in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87877#M38532</link>
    <description>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</description>
    <pubDate>Wed, 14 Jun 2017 00:06:00 GMT</pubDate>
    <dc:creator>erick_tauil</dc:creator>
    <dc:date>2017-06-14T00:06:00Z</dc:date>
    <item>
      <title>Now() formats varies</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87876#M38531</link>
      <description>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?</description>
      <pubDate>Tue, 13 Jun 2017 14:34:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87876#M38531</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-06-13T14:34:00Z</dc:date>
    </item>
    <item>
      <title>You could use FormatDateTime</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87877#M38532</link>
      <description>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</description>
      <pubDate>Wed, 14 Jun 2017 00:06:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87877#M38532</guid>
      <dc:creator>erick_tauil</dc:creator>
      <dc:date>2017-06-14T00:06:00Z</dc:date>
    </item>
    <item>
      <title>Hi,…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87878#M38533</link>
      <description>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 ?</description>
      <pubDate>Fri, 02 Feb 2018 16:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87878#M38533</guid>
      <dc:creator>manalishah</dc:creator>
      <dc:date>2018-02-02T16:49:00Z</dc:date>
    </item>
    <item>
      <title>We have the same issue</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87879#M38534</link>
      <description>We have the same issue</description>
      <pubDate>Wed, 07 Feb 2018 21:36:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Now-formats-varies/m-p/87879#M38534</guid>
      <dc:creator>HarishPulipati</dc:creator>
      <dc:date>2018-02-07T21:36:00Z</dc:date>
    </item>
  </channel>
</rss>

