hello guys, well this time its a problem for datepart function well our one server is lying in Michigan and the other i.e. local server is lying here in india, now the problem is of time i.e. the time of michigan is 10 hours late e.g. when its 25th November 11:OO:AM here the time over there in michigan is (24th November ) so when we want to display the records we r getting problems our customers are shouting ..so timely help will save my job plz reply fast ASAPThank u Keyur

Hi Keyur,First of all i have one query,Where your customers are?In India, In US or All Over the World?If they are in India or USA then you can follow the solution suggested by Sica.(You have to add/Substract that much of the Hours)And if your customers are spread all over world, then this solution will not work. For that you have to trap time zone and according to Time Zone you have to calculate Date and time.

thanks sandesh and sica for ur quick reply. well are customers are in india and some of them are spread in the US . and our server is in michigan so we are having these date problems. will definetly try the dateadd fuction and check whether it clicks or not and will get back to u if u have any good solution then they r most welcome thanks once again keyur.