Hi Mark,
You can try converting both variables into a string , Build String and use the fn-FormatDate (date, "MM / d / yyyy")
Hope this can help you
Regards,
Reva Eka Patria
Thank you, Reva! I hadn't tried Build String-- I will try it to practice. I was able to solve the problem using:
Extract Substring from Start of String:
My Wednesday Reminder Date was formatting like this originally: 10/2/2018 12:00:00 AM
So I extracted 9 characters from start of the string which leaves me only with this: 10/2/2018
I am hoping it works with single digit months as well, but maybe that's where I'll need to build a string. Would the space at the end be part of the date if I extract 9 characters from the beginning of a date with a single digit month? 9/2/2018#
I wonder if that would mess up my workflow then.
Hi Mark.
If you use your solution then you will find a problem like that.
You can use the "string build" or "Set Variable" action with FormatDate Function and the result is a String Format.
fn-FormatDate(dateCreated,"MM/d/yyyy")
Resutl : 02/17/2017
So you can compare it.
If the answer is correct, So please mark the answer as correct.
Regards,
Reva Eka Patria
Hi All,
I have a leading 1 in my Date Column values in SharePoint List.
The Data is like Below.
Date Opened = 760308 ,731225,990125,970609,970702,1000112
760308 = March 8th, 1976
731225 = December 25th, 1973
990125 = January 25th, 1999
970609 = June 9th, 1997
970702 = July 2nd, 1997
1000112 = January 12th, 2000
Basically,I need to change them into MMDDYYYY format.Is there a way we can achieve this format by removing the leading 1 in front of dates .Please let me know if you have any questions.Thank You
This forum is for Nintex O365. There are no inline functions for O365. Your screen shot is for Nintex for SharPoint on-premise.