time stamp format

My rdl file show timestamp as 9/23/2013 11:10:04 AM  with Now() function.
I would like it to show as format like 16:20 23 September 2013. (seconds is removed too)

I tried but not successful. Please help. Thanks.
LVL 1
minglelinchAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
The expression stays the same as =Now().
On the textbox do a right-click:Properties, Number tab.  
In the Category listbox select Custom, and in the Custom Format textbox type

hh:Mm mMMM yyyy

Open in new window

0
minglelinchAuthor Commented:
Thanks for response. I set the property as you said, I still got 9/23/2013 2:12:50 PM.
I need format as 14:12  23 September 2013.

Please help.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Please verify that the expression was typed in correctly, and send us a screen shot.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

minglelinchAuthor Commented:
Attached the screen shot for textbox property setting and the output. Thanks.
PropertySetting.docx
0
ValentinoVBI ConsultantCommented:
This one should do it:

HH:mm dd MMMM yyyy

Open in new window

If you'd like to learn a bit about the different formatting options then I can recommend the following article, written specifically for questions like this: Formatting Dates [SSRS]

Jim: mixing those M's and m's in SSRS does not have the desired effect (possibly different from Access?).  The rule is: use small m's for minutes and capital M's for months.  The more of them you concatenate, the longer the result: MM for month number, MMM for first three letters and MMMM for the full monty...

Ref. User-Defined Date/Time Formats (Format Function)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
minglelinchAuthor Commented:
Thanks. Exactly what I need.
The textbox can only have the date field. If there's a static text concatenated, the textbox won't work in desired way.
Jim's is almost there.

Thank you both.
0
ValentinoVBI ConsultantCommented:
Glad I could help.

The textbox can only have the date field. If there's a static text concatenated, the textbox won't work in desired way.

Not really, you can make use of something called "the placeholder" to mix text and expressions in one textbox.  Each placeholder has its own Format property (in Properties window) and that Format property is actually what you specify through the custom format as explained by Jim.

See this article for more details on that placeholder: The Power Of The Placeholder
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.