hi, im keep trying to get the datetime of end of today... do any1 know whats the syntex...?

here is what i using to get start of the day
StartOfDays=DateTime.today
but i just cant get the syntex to get the end of the day...

Regards
life's Ng

What do u want exactly!? what is the end of the day?!? do u mean time!?!?

Always:),
Hovik Melkomian.

orh thanks Mr.Hovik, im sorry for the tread above, what i actually want is to get the time of the end of the day like this:
10/9/2003 23:59:59

and i use "DateTime.today" to get
10/9/2003 00:00:00

i got another way to achieve what i want this morning, but i dont mind to know more syntax to get the 10/9/2003 23:59:59 :p

Mind if i ask sir another question? pls take a look for my sql statement
dim MySQL as string="Select TimeIn, Staff , ServiceType from ServiceInfo where ServiceType='FollowUp' "

after the where clause, i tried to select those serviceType=FollowUp. Actually i also want to select those serviceType=Routine, i tried to use or as code below, but it dint work...

dim MySQL as string="Select TimeIn, Staff , ServiceType from ServiceInfo where ServiceType='FollowUp' or 'Routine'"

dim MySQL as string="Select TimeIn, Staff , ServiceType from ServiceInfo where ServiceType='FollowUp' And ServiceType='Routine'"

do sir know what i means? i want to select all those record with 'Routine' or 'FollowUp' in ServiceType field... i keep on trying, just cant get it work...
i know its better to use parameters, but if i cant make this work in normal way, i think i'll nv make it work with parameters... thanks for ur advice sir.

Best Regards
life's Ng

Why do you use Or in one of them and And in the other!? The last one should be OK as far as I can see and as long as you replace And with Or... The other will not work for sure. Wrong syntax.

Jacob.

thanks Mr.Jacob! do sir know how to get the 10/10/2003 23:59:59 ?
Cause i think my statement..... not very good....
dim MySQL as string="Select TimeIn, Staff , ServiceType from ServiceInfo where ServiceType='FollowUp' or ServiceType='Routine' And TimeIn like @a "
let say @A value is 10/10/2003, when i execute it, it select all the date, what i wish to c is onli 10/10/2003 record, and it show me 9/10/2003 ..... and so on....well, in my db, the TimeIn value is something like this 10/10/2003 15:20:34 ..... so i think i should use select Between 10/10/2003 00:00:00 and 10/10/2003 23:59:59 ......

Regards
life's Ng