espradli
Scout

What is the replace function for time for a date and time field

Jump to solution

Here is what I have on my Create Appointment action Start and Date inline function, but it is not recognizing the time replacement.

I am trying to create a apt. action for 11:00 on the meeting day, so our admins can have a calendar event to pick up food for the meeting. The want it to always be at 11:00.

So I need to take the meeting start and end date/time and replace ONLY the time from 11:00 to 11:30.

fn-Replace(VarStartDate,"mm/dd/yyyy 00:00:00","mm/dd/yyyy 11:00:00")

fn-Replace(VarEndDate,"mm/dd/yyyy 00:00:00","mm/dd/yyyy 11:30:00")

Reply
2 Replies
vadim_tabakman
Nintex Employee
Nintex Employee

Re: What is the replace function for time for a date and time field

Jump to solution

Hi Emily,

I saw do it with a couple of Regular Expression actions, configured to do a replace.

the expression might look something like this:

\d+:\d+:\d+

and the replacement text would be 11:00:00 or 11:30:00 (for the 2nd one).

Vadim

Reply
mapeacock
Rookie

Re: What is the replace function for time for a date and time field

Jump to solution

Hi,

You use two Calculate date actions, similar to below. Just change the hours field:

Cheers,

Mark

Reply