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

formatting dates inside formula editor 1

Status
Not open for further replies.

cpolonchek

Programmer
May 20, 2002
4
US
I am trying to print out a date within a formula field as a string, and I need to know how to format the field. If I use CStr({FCBT_Deeds_ExhibitA;1.DateField} the field prints out in this format: '12/21/2001 12:00:00 AM'. I would like an alternative so that I can control the format of the date within the formula editor. For example, print out '12/21/2001' or '12:00 AM'. Any suggestions?

Thanks!

Chris
 
CSTR (or totext()) function has a parameter which allows for formatting, check your help file:

totext({FCBT_Deeds_ExhibitA;1.DateField},"dd/MM/yy")

-k




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top