https://community.fabric.microsoft.com/t5/Report-Server/DATES/m-p/1226701#M15063 <P>Hi i want to know why the format of my date looks like sum,</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P> Thu, 16 Jul 2020 04:19:56 GMT abegum 2020-07-16T04:19:56Z https://community.fabric.microsoft.com/t5/Report-Server/DATES/m-p/1226701#M15063 <P>Hi i want to know why the format of my date looks like sum,</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P> Thu, 16 Jul 2020 04:19:56 GMT https://community.fabric.microsoft.com/t5/Report-Server/DATES/m-p/1226701#M15063 abegum 2020-07-16T04:19:56Z https://community.fabric.microsoft.com/t5/Report-Server/DATES/m-p/1227067#M15068 <P>Because it is simply, math<BR />For year 1899</P><P>1899 - 2020 = -121<BR />121 * 12 = -1452</P><P>for MONTH(TODAY())=7<BR />1 - 7 = -6<BR />Finally<BR />-1452 + (-6)= -1458</P><P>What else do you expect?</P><P><BR /><BR /><BR /><EM><STRONG>If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></STRONG></EM></P> Thu, 16 Jul 2020 06:54:31 GMT https://community.fabric.microsoft.com/t5/Report-Server/DATES/m-p/1227067#M15068 saglamtimur 2020-07-16T06:54:31Z