How to add only date column with specific date for all the rows?

[Anonymous]

Hi,

I've below table which has only two columns (Place & Value) wtih few rows, for each rows  I wanted to add hardcoded date as 01,01,2020 date column. How to achieve this?

[Anonymous]

Thanks! that worked so perfectly.

Also I've only Year Column how to make date out of it.

Example:-

Year

2020

2018

Expected 

Date

1,1,2020

1,1,2018

How to achieve this. Many Thanks 

[amitchandak · Accepted solution]

@Anonymous , new column as

new date = date([year],1,1)

[amitchandak]

@Anonymous , add a new column

new column = date(2020,01,01)

This will be in date format