Results 1 to 2 of 2

Thread: date/time games

  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: date/time games

    i need to modify a user specified "event" date.

    some "events" just need the time modified to reserved times between 21:00 and 03:00 whilst other "events" need the day-of-the-month set first/last as well as the time modification.

    there are eleven event "types" with different rules.

    i have two functions which work perfectly but they are not very nice: they either involve cheats (dates-as-doubles) or they involve endless lines of dateadd()

    any ideas for a "compound dateadd()" that handles d, h, n, s in one go but doesn't resort to dates-as-doubles tricks?

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    That would depend on your rules. but dates in reality are longs i think. so i see no problem with working them as they are...

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •