Solved

How to format a date in an o365 workflow?

  • 13 June 2019
  • 2 replies
  • 146 views
F
Badge +3

How do I format a datetime in a 0365 workflow.

I tried the:

fn-FormatDate({Current Item:MyDate}‍, "yyMMdd")

But that just outputs:  fn-FormatDate(6/1/2019 3:45:00 PM, "yyMMdd") 

I know there are the insert options to select ISOFormatted, Long/Short Date/Time but none of those work for the format I need.   ISO is the closest, but since it returns the value in GMT the date/time can appear to be off to users (since they don't expect GMT)

 

As an added wrinkle I need it in 24hr time.

 

Any suggestions?   

icon

Best answer by fb123 25 June 2019, 18:29

View original

2 replies

F
Badge +3

So the best solution I could come up with is to use regex and extract the digets from the datetime as string (/d+)   then I created a parallel process to pad with 0's  and change the hours to 24hr time (based on AM/PM) and then finally did a string builder to combine all the values in the order I wanted.


And extra 20+ actions but it works.

I
Badge +1

Has anyone found another way? i tried the regex to pull the year of a variable date but when i combine it with my other variables it shows up with a bracket and quotes. ex ["2019"] instead of just the number. 


 


i used this - (dd)w+


date: 9/17/2019 12:25:23 PM

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings