Post reply

$LASTDAYOFMONTH

  • January 22, 2018 at 5:41 pm

    #342448

    Hi, I was just looking into a report for a client that's now running a lot slower than usual and it has the following line in the WHERE clause:

    And DeliveryDt <= '$LASTDAYOFMONTH'

    The DeliveryDt column has a data type of  DATETIME.

    Does anyone know what $LASTDAYOFMONTH means, or how it translates into a datatime data type?

    Thanks in advance 🙂

  • January 22, 2018 at 6:02 pm

    #1976844

    Never mind, this is just a place holder, the client manually inputs this value.

    Thanks guys.

  • February 1, 2018 at 7:52 pm

    #1978292

    If DeliveryDt contains (will possibly ever contain) a time portion (the data type DATETIME would allow that) then the condition

    And DeliveryDt <= '$LASTDAYOFMONTH' will omit all deliveries from the $LASTDAYOFMONTH.

    Always use And DeliveryDt < @FirstDayOfNextMonth

    _____________
    Code for TallyGenerator

  • February 1, 2018 at 9:29 pm

    #1978294

    Sergiy - Thursday, February 1, 2018 7:52 PM

    If DeliveryDt contains (will possibly ever contain) a time portion (the data type DATETIME would allow that) then the condition And DeliveryDt <= '$LASTDAYOFMONTH' will omit all deliveries from the $LASTDAYOFMONTH.Always use And DeliveryDt < @FirstDayOfNextMonth

    Heh... it's "deja vu all over again." 😀  Must be a trend.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply