Recent content by kerkerak

  1. K

    Changing date format for optional field

    I need to do some date calculations on an optional date field that is current in YYYYMMDD text format. I can get the date to format by using: DateValue(Format(CLng([Date]),"0000-00-00")) However, it returns an #Error if the field is blank. I'm trying to write in the builder to leave the...
Back
Top Bottom