New Response
Cancel
Copy to Archive
Move to Archive
Document Library
Main Topic
Kurt Tomicich
2005/02/15
Procedure
Reference
Subject:
Combining fields and formatting for numerical sort
Category:
Tips\ Notes\ Programming
Version:
Revision Date:
2005/02/15
Modified:
2005/03/07
Reviewers
Originator
Previous
Current
Future
Kurt Tomicich
Kurt Tomicich/KRT
None
None
Situation:
Two fields -
"Year" is a 4 digit year
"MonthDay" is a 3 or 4 digit value reflecting month and day where, if the day is a single digit, it is padded with a zero
I wanted to display the Date as a single view column and sort it chronologically.
Used this code:
jDate:=@Text(MonthDay);
@If(@Length(jDate)=3;@Left(jDate;1)+"/"+@Right(jDate;2);@Length(jDate)=4;@Left(jDate;2)+"/"+@Right(jDate;2);MonthDate)
Submitted for review on 2/15/2005
Review completed by Kurt Tomicich on 3/7/2005
All Documents
   
By Author
   
By Category
   
By Alternate Name
   
Review Status
   
Help