Does anyone know how to add a formula column that takes the date automatically based on the time period selected?  For example, if I'm loading data in the September 2020 month that doesn't have a date column, is there a way to add a formula column that grabs the date based on the month the data was loaded into?  I'm trying to avoid manually having to add the date to the source file every month.

Has anyone else done this before? @Debbie Hagen, @Jenny Franklin? I am in the same boat I am generating adjustment transactions and need to assign a date/period so the Date Partition function will work properly. 

Shannon

Hi @Shannon Lynch, Ooh, I haven't done that.  Tagging a few folks who may have.  @Katie Mansfield, @Chris Davidsonn, @Michael Moulsdale, @Mark Johnson

Hi there,

you will need to use the CurrentDate() function. There are a couple of different formats you can put into this function to determine how the date is represented and more details can be found at CurrentDate function.

CurrentDate("MMM yyyy") will return "Sep 2020" (ie. the three letter month name and 4 digit year)

CurrentDate("MMMM yyyy") will return "September 2020" (ie. the full month name and 4 digit year)

CurrentDate("MMM yy") will return "Sep 20" (ie. the three letter month name and 2 digit year)

Regards,

Mark

Thanks for the super quick response @Mark Johnson!

Fantastic! That solved my issue!!! Thank you @Debbie Hagen and @Mark Johnson