Auto select a choice based on a office field and 2 milestone date fields

10-01-2020 05:46 PM
Occasional Contributor III

What's the best way to populate a department section based on a filter which works and 2 milestone date fields? I'll provide an example below if someone could help! Thanks!

Tags (1)
0 Kudos
1 Reply
Esri Regular Contributor

Hi Jordan,

Are you looking to generate a single value that contains the office, department, initial first call date, and contact date? If that's what you're looking the simplest approach would probably be to create a field that concatenates the desired fields.

Since it looks like the department field already incorporates the value for office, that could look like this:

Note that the date values will be in decimal date format, so you may need to specify the date format depending on how you want to use the concatenated value.


0 Kudos