16 Replies Latest reply: Feb 25, 2016 8:20 PM by Sunny Talwar RSS

    Date with string problem

    Shan Ahmed

      Hi,

       

      I have a Month column that contains Months value Like this 'January', 'February' and so on. I have a Year field that contains Year Value Like this '2014', '2015' and so on.

       

      I would like to tie this two column and make a date field and then calculate the max date from this field.

       

      The problem is when i concatenate this two field and make one date field i cant calculate max date from that date field. I think the reason behind is, i am concatenating string and number.

       

      Could anyone help me out this problem?

       

      Thanks,

      Ahmed100