Help to convert DATE & TIME to month format

Joan Lopez

HI! The reporting tool I extract the data from provides the date as 10/30/2019 04:58 pm and I would like to know how to convert this to a Month format. Help please?

Paul Newcome

Try this...

=VALUE(LEFT([Column8]@row), 2)

Joan Lopez

Thanks, Paul. Tried it and it said Incorrect Argument

Paul Newcome

Sorry about that. I misplaced a parenthesis.

=VALUE(LEFT([Column8]@row, 2))

Joan Lopez

It worked!!!!! Thank you so much, Paul!

Joan Lopez

And if I wanted to get the year, what would I use?

Paul Newcome

Try this...

=MID([Column8]@row, 7, 4)

Joan Lopez

That worked! I appreciate your help!

Paul Newcome

Happy to help. 👍️