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!

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

dat format for data parameter

Status
Not open for further replies.

sikkilamkiran

Programmer
Aug 9, 2005
21
IN
Hi,

I have a problem with date parameter.
when the parameter page is populated and user selects the date from the date dialog. the format of display is YYYY-dd-mm but i want ot have my own format like dd/mm/yyyy

Please help out as its urgent.

Thanks & Regards
Kiran sikkilam
 
Do you want to display the date parameter in the proper format? ToText would do that, ToText({your.date}, "dd/MM/yyyy")

If you want the parameter different, I don't know of a method, except to enter it as a string and then use LEFT, MID, RIGHT and DATE(yyyy, mm, dd) to turn it into something Crystal will treat as a date.

It helps to give your Crystal version.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top