Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date formatting

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Apr 11, 2009
136
GB
How in a report do you format a date as 29-Jun-09 rather than 29/06/2009 00:00:00 AM?
 
Sort by date Sort by votes
I have managed to do this with dd-MMM-yy, but for some reason it doesn't work for August...other months work, but August dates are shown as e.g. 13-auA.D.-09
 
Upvote 0 Downvote
Try this (using Today's date as an example):
Code: 
=Format(CDate(Today),"dd-MMM-yyyy")

--------------------------
Web/.net Programmer & DBA
Central PA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

newbieSSRS
  • Locked
  • Question
SSRS - DAte fileld filter and collapsing
Replies
0
Views
189
newbieSSRS
newbieSSRS
BTrees
  • Locked
  • Question
Apply same formatting to Textbox (report title) to All ssrs reports in solution /multiple solutions 1
Replies
1
Views
187
kray4660
kray4660
feltonam
  • Locked
  • Question
How to select Patients with >5 Appts and get the very 1st Appt date in same Script
Replies
1
Views
216
johnherman
johnherman
sardine53
  • Locked
  • Question
Date Parameter - Formatting String as Date
Replies
0
Views
71
sardine53
sardine53
dgillz
  • Locked
  • Question
Date Range Parameter not available?
Replies
2
Views
224
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top