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

597
1
10-01-2020 05:46 PM
JordanMiller4
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
BarbaraWebster1
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.

Thanks,
-Barbara

0 Kudos