Month Year String to Date?

I have two columns of data with date information - one Double, with year, and another Double, with Month

I have created another column with Month in String format so I have that as well

I've been able to create a combined String column by converting the Year into String and using the expression [Month]+"-"+[String Year]

I cannot figure out how to convert this to a date field using the DateTimeParse formula

Is there another combination of double/string values I should be using? What other conversions do I need to do?

I've read every help page of time/date to no avail!

Thanks!

Date Time

Accepted answers

RodL

Did you change to a capital 'B'?

All comments

MarqueeCrew

Did you try formatting it as: YYYY-MM-DD? A string in that format is ready for conversion to DATE.

TonyM

If the year format is in yyyy form you can change your expression to [Month]+", "+[Year] (note the space after the comma) and then use the DateTime tool to format your string into a date. The DateTime tool can convert "Month, yyyy" format into a Date.

TheRhino

So if I am understanding you correctly, I should join the two string column (Year and Month) such that it reads "YYYY-MM" - but what is the DateTimeParse output I should use? Can you walk me through that formulation? THank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703