General information
Category:
Coding, syntax & commands
Ed,
Hmmm... thanks for the info. It is a very important problem to the program, which I didn't realised before. So, how do I store them as date, in 99/99 format? Just change the data type as date? Then when retrieving data, just set them as SUBSTR(date,4,5)?
Gan
>
>lets take a simple example where you want things sorted in ascending order, and you have an entry in December of 1999, which you've stored as 12/99, and another in January of 2000, which you've stored as 01/00. You use your sort expression given in the sample code. Which one will appear first?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only