How can I concatenate 2 date fields so that they show the date in long format i.e 18 March 2006 to 21 March 2006. I can get the expression to concatenate but I want to format the dates as above.
Thanks
Concatenate 2 date fields to show longdate format
Hot Topic
- SQL Server 2005 Standard edition install fails; An instance with the same name.../
- COnfiguring Number of records per page?
- Optimizing LIKE OR Selects
- Cannot save my Maintenance plan
- Implicit Keep Together For Export?
- SQL Agent Trouble.
- Stored Procedure Wizard
- Nested data region and data sets
- quick transaction inside a stored procedure question
- Connecting to SQL server 2005 express in LAN Using C# express
SQL Server
- How can I get rid of the comma in a company name by using sql command?
- SSIS package doesn't execute as a job step
- Error occurred retrieving child nodes
- Soundex support for foreign languages
- How to create a DTS package in SQL 2005?
- Error when trying to preview report that retrieves information from SSIS
- Obscure error while attempting to install SQL Server 2005 SP1
- Concatenate field based on unique id.
- SSIS in vb.net 2003
- Changing variable scope in package templates?
Concatenate 2 date fields to show longdate format
Kaboo
I believe you can use this...
=CDate(Fields!date1.Value).ToString("dd MMMM yyyy")&" to "&CDate(Fields!date2.Value).ToString("dd MMMM yyyy")
where you can replace the fields where appropriate.
Craig