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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting Dates from parameter values

Status
Not open for further replies.
t16turbo

t16turbo

Programmer
Mar 22, 2005
315
GB
Hi there, I have a text control in the 'before' section
which includes 2 data parameters:

Code: 
"Date Range: " & param_start_period & " - " & param_finish_period

how can I format these to dd-mmm-yyyy format?
 
Sort by date Sort by votes
I assume data type of param_start_period is date.

You can use format function as follows:

format(param_start_period,"dd-mmm-yyyy")

I hope this helps.

-- JB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

aashish4maximo
  • Locked
  • Question
Trying to make multiselection value enabled input parameter in Actuate+Maximo
Replies
0
Views
89
aashish4maximo
aashish4maximo
Abouelela88
  • Locked
  • Question
How can I pass the current (logged in) user as a report parameter?
Replies
0
Views
88
Abouelela88
Abouelela88
carlos2
  • Locked
  • Question
Overiding ObtainSelectStatement to Add a Report Parameter
Replies
1
Views
89
carlos2
carlos2
optyman
  • Locked
  • Question
Actuate eRD Pro 11SP3 failing with potential bad characters from Sharepoint 2010
Replies
0
Views
81
optyman
optyman
MrZeroPercent
  • Locked
  • Question
Actuate parameter in report title/textbox
Replies
1
Views
63
HelpOnline
HelpOnline

Part and Inventory Search

Sponsor

Back
Top