https://community.blueprism.com/t5/University-Forum/date-function/m-p/86775#M1748 no, my system time format is month/date/year and I cant convert it to date/month/ year the option is not available<BR /><BR />------------------------------<BR />Raghib Ehsan<BR />------------------------------<BR /> Tue, 04 Feb 2020 07:23:00 GMT RaghibEhsan 2020-02-04T07:23:00Z https://community.blueprism.com/t5/University-Forum/date-function/m-p/86773#M1746 <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="32884.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/32984iCF87182AB0E4B8C3/image-size/large?v=v2&amp;px=999" role="button" title="32884.png" alt="32884.png" /></span> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="32885.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/32985iAAC13D7990B1141E/image-size/large?v=v2&amp;px=999" role="button" title="32885.png" alt="32885.png" /></span> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="32886.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/32986iD4D3558803851FCF/image-size/large?v=v2&amp;px=999" role="button" title="32886.png" alt="32886.png" /></span><BR />Why am I getting a different answer? please help!<BR />and where can i get more information on "Functions"</DIV> </DIV> </DIV><BR /><BR />------------------------------<BR />Raghib Ehsan<BR />------------------------------<BR /> Tue, 04 Feb 2020 06:17:00 GMT https://community.blueprism.com/t5/University-Forum/date-function/m-p/86773#M1746 RaghibEhsan 2020-02-04T06:17:00Z https://community.blueprism.com/t5/University-Forum/date-function/m-p/86774#M1747 Hi Raghib,<BR /><BR />Do check if your system time format is in&nbsp; Date/Month/year format and try the below code in the expression.<BR /><BR />Thanks! <PRE class="language-markup">FormatDate("02-11-2016", "dd MMMM yyyy")​</PRE><BR /><BR />------------------------------<BR />Ravi Teja<BR />RPA Developer<BR />Accenture<BR />Asia/Kolkata<BR />------------------------------<BR /> Tue, 04 Feb 2020 06:32:00 GMT https://community.blueprism.com/t5/University-Forum/date-function/m-p/86774#M1747 RaviTeja 2020-02-04T06:32:00Z https://community.blueprism.com/t5/University-Forum/date-function/m-p/86775#M1748 no, my system time format is month/date/year and I cant convert it to date/month/ year the option is not available<BR /><BR />------------------------------<BR />Raghib Ehsan<BR />------------------------------<BR /> Tue, 04 Feb 2020 07:23:00 GMT https://community.blueprism.com/t5/University-Forum/date-function/m-p/86775#M1748 RaghibEhsan 2020-02-04T07:23:00Z https://community.blueprism.com/t5/University-Forum/date-function/m-p/86776#M1749 That's the reason. BP uses dotnet assembly files which are again picked from your system. So if your system is set in a different date time format, the results will vary.<BR /><BR />------------------------------<BR />Vivek Goel<BR />RPA Architect<BR />Asia/Singapore<BR />"If you like this post, please press the "Recommend" Button.<BR />------------------------------<BR /> Tue, 04 Feb 2020 07:57:00 GMT https://community.blueprism.com/t5/University-Forum/date-function/m-p/86776#M1749 vivek.kumar.goel 2020-02-04T07:57:00Z