: How To Find Persons who born
today ?
(birthdate)
Thanks Rosyee,
But I have to find persons from ContactPerson table.
And there more than 200.000 records in there.
And this method will not be sufficient for finding 5 or maybe
max 10
person from there.
Best Regards
NazimSoftware Engineer MazikPakistan - Dynamics DivisionEmail : [EMAIL
PROTECTED]
To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Fri, 2 Nov 2007 18:17:16
+Subject: [development-axapta] Re: How To Find Persons who born today ?
(birthdate)
The following code will find users who's month and day match
[mailto:[EMAIL PROTECTED] PÃ¥ vegne af Ali
Ãhsan Aðca
Sendt: 24. oktober 2007 12:52
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Re: How To Find Persons who born
today ?
(birthdate)
Thanks Rosyee,
But I have to find persons from ContactPerson
-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] PÃ¥ vegne af Ali
Ãhsan Aðca
Sendt: 24. oktober 2007 12:52
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Re: How To Find Persons who born
today ?
(birthdate)
Thanks Rosyee,
But I have to find persons
@yahoogroups.com
[mailto:[EMAIL PROTECTED] På vegne af Ali Ýhsan Aðca
Sendt: 24. oktober 2007 12:52
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Re: How To Find Persons who born today ?
(birthdate)
Thanks Rosyee,
But I have to find persons from ContactPerson
: [development-axapta] Re: How To Find Persons who born today ?
(birthdate)
Thanks Rosyee,
But I have to find persons from ContactPerson table.
And there more than 200.000 records in there.
And this method will not be sufficient for finding 5 or maybe max 10
person from there.
Best Regards
af Ali Ýhsan Aðca
Sendt: 24. oktober 2007 12:52
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Re: How To Find Persons who born today ?
(birthdate)
Thanks Rosyee,
But I have to find persons from ContactPerson table.
And there more than 200.000 records
Hi Ali,
You can use like this
while Select emplTable
{
if( mthofyr(emplTable.BirthDate) == mthofyr(today())
dayofmth(emplTable.BirthDate) == dayofmth(today()))
{
//u'll get records who born on same day as today
}
}
Hope this is what you are
Thanks Rosyee,
But I have to find persons from ContactPerson table.
And there more than 200.000 records in there.
And this method will not be sufficient for finding 5 or maybe max 10
person from there.
Best Regards...
--- In development-axapta@yahoogroups.com, Rosyee [EMAIL PROTECTED] wrote:
Hi
Thanks for your reply but I didn't mean born today, I mean were born
today (birthdate is today).
--- In development-axapta@yahoogroups.com, Anil Ozay [EMAIL PROTECTED]
wrote:
Hi Ali,
EmplTable EmplTable;
TransDate today;
;
Today = today();
WHILE SELECT
I thought so. But I think there must be a way to include that case in
query filter string
Thanks...
--- In development-axapta@yahoogroups.com, Max Belugin
[EMAIL PROTECTED] wrote:
I think, the only way is to enumerate dates from today back to 1900.
(AFAIK there is no way to store dates prior
11 matches
Mail list logo