How can I force a specific date_time_format f...

(Jonas /) #1

How can I force a specific date_time_format for now()?

I got the issue that one of our pcs has an english OS, that results in a different time-format and some problems.

two possible solutions:

#1 set the date_time_format globally within app

#2 set the date_time_format in expression


(Jonas /) #2


(Aleksi Alkio) #3

If you create that format by yourself, you have the control and your customers won’t misread it.

(Grant Stead) #4

@Philip_Garrett_Appsh knows more about dates and times but he explained to me once that appsheet tries to do a good job moving back and forth… So if your sheet is US and column type date, and the device is Colombia, it should store the date in the sheet as that stupid number, 42756, and display it pretty their device settings…

(Jonas /) #5

The issue is more about an email that is being send to the customer. The format is english but the customer is geman, so he get’s confused.

Its an email to tell our customer the date & time of arrival.

If the client that triggers that email happens to work on an english OS, the problem occurs

(Aleksi Alkio) #6

Create your “own” format in that workflow rule so you can always be sure it’s the same.

(Jonas /) #7

you mean something like

concatenate( hour(DATETIME), minute(DATETIME))


(Aleksi Alkio) #8

I was thinking something like “January 21, 2018” where everybody will understand it correctly.

(Jonas /) #9

that would work as well. Still think it would make sense to have some control over the formatting