Need to convert text to date

Sandhiya07

Hi Everyone,

I have the value which is calculated from "Date with Time" column, which is text type. I need to convert the text value into date.

Kindly help us on this.

Thanks,

Sandhiya P

Brucey

Hi @Sandhiya07

I would change the "Issue reported date" column to be a date column

and the formula to be =IssueReportedTime@row

Does that make sense? So you can have the date/ time stamp and the specified date column will pull the correct information.

Sandhiya07

Hi @Brucey ,

No it's not worked out, again comes with time also. Please refer the screenshot below,

Thanks,

Sandhiya P

Jeff Reisman

@Sandhiya07

You are almost there. In the Issue Reported Date column use this formula:

=DATEONLY([Issue Reported Time]@row)

The DATEONLY function just takes the date portion of the value in the datetime column.