Converting a year (YYYY) in string format, to a date field

Hi everyone

Within my table I have the following Year column and I want to convert it to the Date column:

Year (string format)	Date (date format) *(desired format)*
2020	01/01/2020
2021	01/01/2021
2022	01/01/2022
2023	01/01/2023
2024	01/01/2024

I want to do this so I can utilise line chart visualisations in Power BI.

I've tried using the DateTime tool but can't locate an incoming string YYYY option to convert. I'm thinking the Formula tool can resolve this and help with formula type would be appreciated!

Can anyone help?

Thanks
KA

Date Time

Help

Power BI

Accepted answers

MarqueeCrew

@arundaka02 ,

how about trying:

"01/01/" + [year]

or try

"01/01/" + ToString([year])

cheers,

mark

All comments

MarqueeCrew

@arundaka02 ,

how about trying:

"01/01/" + [year]

or try

"01/01/" + ToString([year])

cheers,

mark

ImadZidan

Hello @arundaka02 ,

see example in the workflow.

Hope it helps.

If you are looking for 01/01/2020 or similar as a date output, I am afraid this is not possible.

Dates in Altyrex are all set to yyyy-mm-dd format.

DatStrOutput.yxmd

arundaka02

Thanks @ImadZidan

I've just learnt that this is the case when I've converted it to a date format with DateTime!

I can now however complete linear visualisations in Power BI. thanks @MarqueeCrew

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335