Loading...

Formatting Dates in EZWriter Reports

Comments

6 comments

  • Kris Corrigan

    how can we return the month to a full month as opposed to Jan, Feb etc

  • SELECT DATENAME(MONTH, GETDATE())

  • Kris Corrigan

    Thanks Lee

  • Elisabeth Bollmann

    I would like to filter for only the events of the next 14 days, but somehow the EZWriter Data Source does not display a result on WRI. Does anyone have a tip on how to combine the SQL for CONVERT, DATEADD and GETDATE ?

    FROM EV200_EVENT_MASTER

    WHERE (EV200_EVT_END_DATE>CONVERT(DATE,DATEADD(DAY,14,GETDATE())))
    AND (EV200_EVT_START_DATE<=CONVERT(DATE,GETDATE()))

    When I set the EVT_END_DATE to >CONVERT(DATE,GETDATE())) all events from today are displayed.

     

    Thanks!

  • Dustin Banks

    I believe you have you greater than and less then backwards

    FROM EV200_EVENT_MASTER

    WHERE (EV200_EVT_END_DATE<CONVERT(DATE,DATEADD(DAY,14,GETDATE())))
    AND (EV200_EVT_START_DATE>=CONVERT(DATE,GETDATE()))

  • Elisabeth Bollmann

    Hi Dustin, thanks for spotting this. Now it works!

Please sign in to leave a comment.