coding for sorting an unusual character string

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Hi,
I am new to programming and having difficulty coding
this. I want to sort the following DateTimeGroup in order
of most recent first on a form: ######ZOCT01

The first four characters are the time, the next 2
are the day. The Z will always be displayed in the 7th
character position from the left. I have tried to parse
the data in the QDE design grid with the following as a
start: Expr1:Right([DateTimeGroup],2)

Of course the effect is that it does not do what I want.
How would I program this to sort? Any hints and/or
beginning lines of code provided would be appreciated.


Thank you,

Jon
 
The following will give you the date in the following
format ddhhhh

Mid([Field1],5,2) & Left([Field1],4)

where d is the day and h is the time...

Not sure if this is what you're looking or or not.

HTH,

Jason
 
Back
Top