How's about "Sort" Month / Day without year in birthday date field?

Daniel R. Sloan

"Daniel R. Sloan" wrote:
Two calcs based on the full date field of format xx/xx/xxxx

Day: Left (DateField, 2)
Month: Middle (DateField, 4, 2)

Then sort on those in order

Cheers

Webko

In article <jlKTa.131701$N7.19170@sccrnsc03>,
"Daniel R. Sloan" <danielsloan (AT) comcast (DOT) net> wrote:

If the field is actually a date type then you could have a calculated
field of:

(month(bdate) * 100) + day(dbate)

This will give you numbers like:

131 - for Jan 31
1202 - for Dec 2

You can then sort on this calculated field.

--
Matthew Smith
(to reply via email remove xxx)

[posted and mailed]

"Daniel R. Sloan" <danielsloan (AT) comcast (DOT) net> wrote in news:jlKTa.131701
$N7.19170@sccrnsc03:



I know this may be a little late but . .

I found the easiest way is to sort by month and date sans the year is to
use the following calculated field -

zc.SortDate(text): If( Month( Date ) < 10 , "0" ,"" ) & Month( Date ) &
"." & If( Day( Date ) < 10 , "0" ,"" ) & Day( Date )

you end up with a calculated result like 03.12 for a date of 3/12/2001 and
it should sort just fine.