cancel
Showing results for
Did you mean:

How to convert date from month and year?

NiCd Battery
Hi all,

I have imported the data and I have columns Month and year. (Year :  2019, 2020 etc.) and Column "Month" (string format - like "Jan", "Feb", etc.).

Now I need to create new column with acceptable date from these two columns. e.g. if I use from "Year" - 2019 and from "Month" - Nov, I need to get 11/1/2019 and so on.

Can someone help me with this?

Regards,

Praveen

Labels (1)
• Data Prep

3 Replies
Highlighted
NiCd Battery
Hi Praveen,

You can use a computed column (let's call it New_Date) with the following expression:

@Month@ + "/1/" + @Year@

Alternatively, you can also use concatenate function as well (provided as part of computed column functions):

CONCATENATE(@Month@, "/1/", @Year@  )

If you are planning to use "New_Date" for date-related logic then it's a good idea to convert it into a date.

I hope this helps,

With Best Regards
Sudheer Kumar
Highlighted
NiCd Battery
Hi Sudheer,

I am getting error for the following formula :

DATE(@Month@+ "/1/" + STR(@Year@))
↳ Expected three arguments

Regards,
Praveen
Highlighted
NiCd Battery
Hi Praveen,

The function DATE expects a numeric or integer inputs. Day value should be just 1 not "/1/". You need to convert any string values to numeric. The details from our context help are shown below:

DATE
Takes three separate arguments and combines them to form a date in a new DateTime column.
 Syntax: `DATE(YEAR, MONTH, DATE)`YEAR is four-digit valueMONTH is two-digit valueDATE is two-digit value Example: `DATE(@year@, @month@, @day@)` Notes on use: Leading zeros for MONTH and DATE are not supported, for example:`DATE(1999,05,08)` should be expressed as `DATE(1999,5,8)`
With Best Regards
Sudheer Kumar