I have Converted date in a column as a string like 03/10/2015 and I would like to compare this field with a manual date(Ex: 03/28/2015) in formulas. I am not getting 100% correct results few of the records are missing.
Ex : IF(GT(#text_create_date;"03/28/2015");"Complete";"Not Complete")
few of the records are not giving correct results Ex : for 03/01/2016 text_create_date it is throwing me "Not Complete" results.
Please help me on this.
Please sign in to leave a comment.