Post reply

Add time

  • January 22, 2015 at 2:40 am

    #296806

    Hi all

    how do i add time to the following expression :

    + FORMATDATETIME(DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today)),DATEFORMAT.LongDate)

    please help

  • January 22, 2015 at 7:52 am

    #1772229

    =DATEADD("n",150,Fields!orderdate.Value)

    n = Minutes (because M is months)

    h = hours

    s = seconds

  • January 22, 2015 at 11:57 pm

    #1772498

    hi thanks for the response.

    i need to add time to my query.

    what i am doing in the code is calculating the Sunday of every month.

    all i would like to add is a time to that piece of code.

    if you could assist i would be highly appreciative.

  • January 23, 2015 at 9:02 pm

    #1772870

    post your table or query definition. Adding time works exactly the same as adding days.

    https://msdn.microsoft.com/en-us/library/ms186819.aspx

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

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