11183
May 23, 2020, 6:59am
1
I use two time formula to show time information, but I can’t change time formula’s format.
#Now ()
Default format was MM/DD/YY HH:MM:SS AM/PM
I want to use this:
YY/MM/DD AM/PM HH:MM:SS
or
YY/MM/DD AM/PM
#Date (2019, 7, 4)-Now()
Default format was Day Hrs Mins Secs
I want to use this:
Day
You can reference this image, red sentence was what I want.
Example Code doc is here:
Not sure if helpful, but did you checkout this post:
Hi,
Could someone please show me how to display the output of time-based formulas in 24hr time?
For example, I would like the output of my formula below to generate:
Wed, 1 Apr 2020 17:17:13 +1000
instead of:
Wed, 1 Apr 2020 5:17:13 PM +1000
Concatenate(Format("{1}, {2} {3} {4}",left(Today().WeekdayName(),3),Today().Day(),left(Today().MonthName(),3),Today().Year())," ",ToTime(Now())," +1000")
Any help would be greatly appreciated.
11183
May 24, 2020, 9:13am
3
Thanks to your reply!
Because of I am not native English speaker ,the article have too many words so I can’t understand in detail…
But I found a method to resolved by myself!
The detail could see the image and coda doc.
Anyway, thanks too much!
1 Like