Post reply

=WeekdayName(weekday(Today())) gives me tomorrow

  • March 2, 2015 at 2:00 am

    #301619

    Hello

    I have noticed with one of my reports, when I add weekdayname, that tomorrow's value appears.

    I tested this by adding a textbox with =WeekdayName(weekday(Today())) in it. I have just run this (on a Monday) and it is saying Tuesday. So clearly it's one day out.

    Does anyone know how I can go about rectifying this? I can get round it in reports by adding an expression but I suspect there's some deeper problem that I would like to rectify.

    Any advice would be much appreciated.

    Thanks.

  • March 3, 2015 at 11:07 am

    #1781452

    faulknerwilliam2 (3/2/2015)

    Hello

    I have noticed with one of my reports, when I add weekdayname, that tomorrow's value appears.

    I tested this by adding a textbox with =WeekdayName(weekday(Today())) in it. I have just run this (on a Monday) and it is saying Tuesday. So clearly it's one day out.

    Does anyone know how I can go about rectifying this? I can get round it in reports by adding an expression but I suspect there's some deeper problem that I would like to rectify.

    Any advice would be much appreciated.

    Thanks.

    The Today() function is based on the server's date/time/time-zone settings in Windows.

Viewing 2 posts - 1 through 1 (of 1 total)

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