Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / February 2006

Tip: Looking for answers? Try searching our database.

Datetime Parameter Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin - 17 Feb 2006 04:13 GMT
Hi,all
I have a datetime parameter,
I use calendar to select value,but I want to format it as "yyyy-MM"
Any suggest?Can I use expression,how to ?
Kevin Chu
Tom - 23 Feb 2006 07:13 GMT
Just get the value in as datetime format and use
format(Fields!xxx.Value,"yyyy-MM")

Signature

Tom Stude

> Hi,all
> I have a datetime parameter,
> I use calendar to select value,but I want to format it as "yyyy-MM"
> Any suggest?Can I use expression,how to ?
> Kevin Chu
Kevin - 28 Feb 2006 02:19 GMT
=?Utf-8?B?VG9t?= <membership@stude.no> wrote in news:ADC758F7-F6A7-4F56-
8C5C-1BAD643ABF30@microsoft.com:

I want to show "yyyy-MM" format in preview,not get the value

> Just get the value in as datetime format and use
> format(Fields!xxx.Value,"yyyy-MM")
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.