SSRS Date format help required
-
Hi Team I need to show date in this format in my report -----------Dec'09 I am getting format like this Dec2009 for this I am using (MonthName(Month(Parameters!sdate.Value),TRUE)& Year(Parameters!sdate.Value)) Please kindly help me how to get format Dec'09 and also How to display previous month date also Nov'09 (Need formula)
-
Hi Team I need to show date in this format in my report -----------Dec'09 I am getting format like this Dec2009 for this I am using (MonthName(Month(Parameters!sdate.Value),TRUE)& Year(Parameters!sdate.Value)) Please kindly help me how to get format Dec'09 and also How to display previous month date also Nov'09 (Need formula)
String date = DateTime.Now.ToString("MMM yy");
However it will return exception if you want " ' " char to be seen.
siddisagar wrote:
How to display previous month date also Nov'09 (Need formula)
String date = DateTime.Now.AddMonths(-1).ToString("MMM yy");