8 Replies Latest reply: Aug 3, 2015 7:02 AM by kumar avisakula RSS

    problem with date

    kumar avisakula

      Hello,

       

      I have a problem with weekstart function.

      I had written a function for date column and it is not working as per my requirement. The formula is

      =weekstart(date([Time Full Date],'DD/MM/YYYY'),0,-1)

       

      and it is resulting  like below

       

      here for jan,feb,march zero's are not appearing. But I need like

      01/18/2015

      02/08/2015

       

      pls help me on this one.

       

      Regards,

      Kumar