Generate a date key

[Nandor]

Hi,

I have a classical Date&Time column in my database.

I would need to add a new column generated from year, month and day.

For example: 20160905 for the 5th of september 2016.

Thank you,

Nandor

[grapefruitmoon · Accepted solution]

In Power Query/M you could use:

Date.ToText([DateColumn], "yyyMMdd")

[tjd · Accepted solution]

Nandor -

Try this: DateInt = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])

[cabc_xlorla]

All excellent solutions!

1. Date.ToText([DateColumn], "yyyMMdd")

2. DateInt = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])
3. =FORMAT ( [YourDateField], "YYYYMMDD" )

thanks everyone!

[Framet · Accepted solution]

Hi,

Some very valid suggestions, my personal choice would be to have the following calcualted column:

=FORMAT ( [YourDateField], "YYYYMMDD" )

Cheers

[tjd · Accepted solution]

Nandor -

Try this: DateInt = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])

[grapefruitmoon · Accepted solution]

In Power Query/M you could use:

Date.ToText([DateColumn], "yyyMMdd")

[Nandor]

Thank you!

All three solutions work perfectly.

Best regards,

N