Help

Auto generate dates in a column

Topic Labels: Dates & Timezones
1100 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daisy_Shobokshi
4 - Data Explorer
4 - Data Explorer

Hello, I’m trying to create a social media calendar.
I want to auto-add every day of the year into a column.
Is there a way?

Screen Shot 2020-12-17 at 1.54.04 PM

1 Reply 1
Brent_Cook
6 - Interface Innovator
6 - Interface Innovator

I am not the person to really be offering advice because I’m sure there is an easier way, but I came up with a workaround to get you by until someone offers the right way. I created a count column and a start date column that contained the date that I wanted (in your case it’d 1/1). Then created a formula column that added the start date and count columns. (DATETIME_FORMAT(DATEADD({Start Date},Count-1,‘DAYS’),‘MM/DD/YYYY’). I’m in this room because I was searching up a way to format the outcome as a date so I can view it in a calendar. Hope this gives you a starting point.