yearmonth as whole number

[Anonymous]

hi,

if i have a date column & i wish to create another column that contains a converted value for yearmonthday as a whole number, kindly advise on how to do so. 

for example, a date '12/08/2020' (i.e. 12th August, 2020) to be converted as 20200812 (yearmonthday) as a whole number type/format.

tks, -nik

[pranit828 · Accepted solution]

Hi @Anonymous 

YYYYMMDD_format = FORMAT('Table'[date],"YYYYMMDD")

Thank you @Greg_Deckler        And then right click the column and change it to a Whole number.

[Greg_Deckler · Accepted solution]

@Anonymous - Just to add to @pranit828 you could then right-click the column and change it to a Whole number. FORMAT retuns a Text value.

[amitchandak · Accepted solution]

@Anonymous ,

Try like

Whole Date = year([Date])*10000 + month([Date])*100 + Day([Date])

or

Whole Date = format([Date],"YYYYMMDD") // This will be the text you need to change data type to whole number

[pranit828 · Accepted solution]

Hi @Anonymous 

YYYYMMDD_format = FORMAT('Table'[date],"YYYYMMDD")

Thank you @Greg_Deckler        And then right click the column and change it to a Whole number.

[Anonymous]

many2 tks, @pranit828 , @amitchandak & @Greg_Deckler .

[Greg_Deckler · Accepted solution]

@Anonymous - Just to add to @pranit828 you could then right-click the column and change it to a Whole number. FORMAT retuns a Text value.