NOW() BUGS BUGS BUGS

AppSheet AppSheet Q&A
, , , , , ,
1

I am using this function but one issue. then i update shelf columns showing wrong datetime. why

Today date is 03 April 2023 10:45:12

Wrong date showing 04 Match 2023 12:35:05

how can i fix this issue.

IFS(
OR(
ISNOTBLANK([PUTAWAY NO]),
ISNOTBLANK([SHELF CODE])
)
,
NOW()
)

IFS(
....ANY of these statements is true:
........1: This statement is false:
............(The value of column 'PUTAWAY NO') is empty
........2: This statement is false:
............(The value of column 'SHELF CODE') is empty
....NOW(
....))
2

Hi @Sirfyaad

This looks like a locale mismatch between your table settings and your database settings.

Are these set the same way?

1 Like