"If" Functionality - Format As Text?

Hi everyone.

Just a question around best practice that’s niggling me. I have a workflow where I effectively want to say:

IF Input A is empty then value is Current Date/Time ELSE Use Current Date/Time.

My usual approach for ease of use is to use the format as text option as it allows for a simple if/else check, but the catch is the data put out must be text.

What should I do in this case, where I want to put out a date value? I know I could just create two workflows with an only when condition, and that’s probably what I’ll do in the meantime.

Just interested to know if there’s a trick I’m missing here.

image

Define the Date elsewhere as a variable.

For example, add a Group with a content type of Date, and leave its data source empty.

Have 2 conditional data sources on the Group:

  1. When Date/TimePicker Time Seen by Clin’s value is empty: Current Date/Time
  2. When Date/TimePicker Time Seen by Clin’s value is not empty: Date/TimePicker Time Seen by Clin’s value

Then in your Make Changes to a thing workflow, just set the Seen by Clin value to that group’s value.

2 Likes