Good afternoon,
I am attempting to auto populate a field based on another field. Here is the situation. I have a form that has multiple dates and times. I am attempting to auto populate my next date field based on a date/time from another field.
1. I have combined a [date] and [time] field by using DateAdd(“n”, 15, [txtDateTime1]) successfully. That was easy
2. I now need to auto populate my next field (let’s call it [Date2]) with a date that is +15 minutes from [DateTime1].
3. To throw a wrench in it, I need to allow the end user to change that date if necessary and not auto populate the time.
Date1 2/27/19
Time1 2315
Need the following:
Date2 2/28/19
Time2 <blank>
Hope this is clearer than mud
any ideas?