Forum Discussion
Solved
How to get a date from monthly data source?
Hi all I have a monthly data source which has date columns showing: I am trying to create a new date column that gives 1st of the month for a standard UK date format e.g. top row would...
My advice is to not create a string, but an actual date column and than add your favorite date format. to create the date (computed) colum: DATE([Year], [MONTHNUM],1)
sjoerdvn
Solution Sage
Solution SageMy advice is to not create a string, but an actual date column and than add your favorite date format. to create the date (computed) colum: DATE([Year], [MONTHNUM],1)