cancel
Showing results for 
Search instead for 
Did you mean: 
bobbygriffiths
Nintex Newbie

Extract 'Day' value as an integer from the items created date

Jump to solution

Hello,

I'm looking for a way to extract the 'day' portion of an items created date.

I'd like to use an 'if' function within my workflow to say: IF the created day is before or equal to ( # ) THEN do this... ELSE...

I have a feeling the answer is buried within the regular expression builder, but I'm not sure.

Any help would be much appreciated.

Thank you,

Bobby

Labels: (1)
Reply
3 Replies
Automation Master
Automation Master

Re: Extract 'Day' value as an integer from the items created date

Jump to solution

does this help? 

Reply
bobbygriffiths
Nintex Newbie

Re: Extract 'Day' value as an integer from the items created date

Jump to solution

Thanks Cassy, using the fn-FormateDate function I was able to build a string that pulled the day out of the created date:

fn-FormatDate({ItemProperty:Created}, dd)

As that was a plain text field I just copied it into an number variable which I then used in an 'IF #var is greater or equal to...' condition.

Got there in the end!

thanks

0 Kudos
Reply
Automation Master
Automation Master

Re: Extract 'Day' value as an integer from the items created date

Jump to solution

excellent bobby.  pleased you got a solution in the end!  please mark an answer as correct to close out the thread.

0 Kudos
Reply