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

CHGDAT

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Joined
Jan 26, 2001
Messages
522
Location
US
I am having problems using this function.

The field is defined as HYYMDS, so it is displayed as
2003/12/31 00:00:00

I can NOT change the format in the master file since there are times when I do need to display the time.

How can I display this field as
12/31/2003



Thanks,

Leo ;-)
 
There are a specific set of subroutines available to manipulate datetime fields, and I think the one you need here is this -

NEW_DATE/YYMD = HDATE(datetime_fld, NEW_DATE);
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top