Default Date in Date Fields

[rickn]

I have two date fields that I want to default to a certain date.
If either of these fields are null CustDueDateCommitted or CustDueDateRequested the date from CustDueDateRequested will update these two date fields. Otherwise, if a date is in either the two fields CustDueDateRequested will not update these two fields.

is this possible?

[TheShabz]

I am noticing an issue with your request.

1. if either is null, CustDueDateRequested will do both.
2. If either is not null, it wont update.

if Committed is not null
and
Requested is null
then ?

[rickn]

I appologize.
The CustDueDateOriginal date field will only give a default date to the CustDueDateCommitted if this field is null; and will only give a date to the CustDueDateRequested field if this is null. Otherwise, a date will be manually entered in the CustDueDateCommited CustDueDateRequested fields.

[TheShabz]

So for either field, if its null, the default will be CustDueDateOriginal.

iif(isNull(CustDueDateCommitted), CustDueDateOriginal, whatever-you-want)

replace the "whatever-you-want" with however you plan on entering the date.

basical logic goes If, then, else. so were checking to see if CustDueDateCommitted is null. If it is, set it to CustDueDateOriginal. else, whatever-you-want.

If this solves your issue, please mark thread solved.

[rickn]

What would be the option if CustDueDateOriginal was null at the onset, and then when the user enters a date in the CustDueDateOriginal, both the CustDueDateCommitted CustDueDateRequested if they are null? Reason is, at first the fields are null for data entry has occured, they the user enters in the date for CustDueDateOriginal.

[rickn]

I acutally used the BeforeUpdate Event for this and works great. That way the defaultis as above and the user can still enter date information afterwards.
Thanks