WEEKNUM() returning 01/01/2021 as Week 01

Did you change the expression to divide by 7.0?

1 Like

Hi Marc,

yes I did. still no change.

1 Like

Are WEEKNUM() and WEEKDAY() returns consistent on both platforms?

1 Like

I have done a test on both platforms (G Sheet and AppSheet). I used the same expression for the Result column, and this is the result:

CEILING( WEEKNUM([Date]) - ( WEEKDAY([Date] - 1) / 7 + 1 ))

AppSheet

image

G Sheet

image

Both platforms deliver a different result for day 7.

Also, when testing the expression, AppSheet shows the right result but delivers a different one (See the image below) :exploding_head:


Very odd :hushed:

1 Like

Looks like a bug to me. Please contact support@appsheet.com for help with this.

1 Like