the format is this 1984-03-03T00:00:00.000Z but require month, date, and year because i want to create a pivot report in google sheets for a monthly report.
can anyone help me with this?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
DATEVALUE converts a provided date string in a known format to a date value.
=DATEVALUE(LEFT(A1,10)) # Time would be similar =TIMEVALUE(MID(A1,12,11))
You would paste the formula down the column or alternatively use the BYROW function.
=BYROW(A:A, LAMBDA(r, IF(r<>"", DATEVALUE(LEFT(r,10)), IFERROR(1/0))))