How to Create a New Date Column Using Day, Month and Year Columns in Bold BI

In Bold BI, you can create a new date column using existing day month and year columns. This can be achieved by using the to_timestamp function and the CONCAT function.

Here is the step-by-step guide:

1. Open the data source where you want to create the new date column.
2. Click on the ‘Add’ button to add a new expression.
3. In the ‘Expression Name’ field, give it a name, like DayMonthYear.
4. In the ‘Expression’ field, enter the following formula:

to_timestamp(CONCAT(cast([Year] as varchar(4)),'-',[Month],'-',[Day], ' 00:00:00'),'YYYY-Mon-dd')

5. Click ‘Save’ to save the new expression.
   
   

Now, you have successfully created a new date column using the month and year columns.

Bold BI supports various data sources for the to_timestamp function such as:

1. MySQL
2. PostgreSQL
3. Oracle Database
4. Microsoft Azure SQL Database
5. Amazon RDS
6. Google BigQuery
7. Snowflake
8. SQLite
9. Microsoft Access.

Note: The availability of the to_timestamp function may depend on the specific syntax and functions supported by each database system.

For SQL server, please utilize the expression mentioned below as it does not support the to_timestamp function.

CONVERT(DATE, CAST([Year] AS VARCHAR(4)) + '-' + [Month] + '-' + [Day])

Additional References

• Configuring Expression Columns in Bold BI
• How to Convert date in String to Date type in Bold BI