Jaselnewpar
SSC Eights!
Points: 979
More actions
April 29, 2011 at 1:42 pm
#235474
Pretty much all in the subject. Instead of using SQL, how would you use expressions to convert a date with the format of: YYYYMM?
April 29, 2011 at 1:53 pm
#1317947
Just when I had given up I found THIS page which gave me the styles I was trying to find.
Answering my own question:
=Format(Fields!AuditLastChangeDate.Value,"yyyyMM")
Jeffrey Williams
SSC Guru
Points: 90303
April 29, 2011 at 3:05 pm
#1317973
I probably would have just set the format on the text box itself, instead of using an expression. The formula would be the same.
Jeffrey Williams“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers fasterManaging Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply