Let's say I have a date (not a datetime) value. For example, September 9, 20

prestonb over 10 years ago

Let's say I have a date (not a datetime) value. For example, September 9, 2014. Right now I'm displaying this value on a form using this expression: datetext(rf!dBusinessDate, "dd MMMM yyyy")

Different users see different values depending on what time zone they are in and its relationship to GMT. Some people see 9 Sep. Others are seeing 10 Sep. What I really want is for everyone in every timezone to see 9 September. How do I format dates so that they do not get adjusted?
...

Discussion posts and replies are publicly visible

0 vanmathyv
Certified Lead Developer
over 10 years ago

Hi Preston,

You can try text(rf!dusinessDate, "dd MMMM yyyy") function to achieve your use case.
Here is the link for your reference for text() function,
forum.appian.com/.../Text_Functions.html

Datetext function interprets the date specified in the user's preferred calendar and returns its string representation using given format.
Here is the link for datetext() function,
forum.appian.com/.../Scripting_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel