Solved

Regular Expression to remove time after the year of the date

  • 25 September 2018
  • 5 replies
  • 548 views
C
Badge +6

 I have  Run If action I am trying to use, but the 2 dates I'm comparing are showing the time after them as well. 

 

Using the Log History action, I found my 2 dates are never comparing correctly because they're coming out like this:

 

Run If  9/25/2018 1:01:45 PM = 9/25/2018 12:00:00 AM

 

I would like an email to send if  9/25/2018 = 9/25/2018     

 

How can I trim the string so only the date shows? I would like the string after 2018 ignored and extracted into a variable because if I count from the beginning or end to trim it, when the month is a 2-digit month the results will be different. I need to change 9/25/2018 1:01:45 PM  to be only 9/25/2018 and extract to a variable. Any ideas? 

 

icon

Best answer by casey 3 October 2018, 20:05

View original

5 replies

R
Userlevel 1
Badge +5


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

C
Badge +6

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. 

R
Userlevel 1
Badge +5

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

S
Badge

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

M
Userlevel 3
Badge +9
This forum is for Nintex O365. There are no inline functions for O365. Your screen shot is for Nintex for SharPoint on-premise.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings