• For such value, u need a Cut OFF date, from onwards, you can calculate the miiseconds till the required date, for example,

    FirstDate = getdate() - 1

    Seconddate = getdate()

    Now, you can calculate teh milliseconds based on the difference of two dates as,

    lets say, if the difference is 1, then 24 hours = 24*60 Minutes = 24*60*60 seconds = 24*60*60*1000 milliseconds

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]