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

[espradli]

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")

[vadim_tabakman · Accepted 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

[mapeacock]

Hi,

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

Cheers,

Mark