Has anyone had any success in mapping Tadabase Record Date fields in MAKE and got it working even when the date field is “empty”? I’m new to MAKE so it may well be a MAKE related issue…
I found that Make failed to map a date field value until I wrapped it with a MAKE DateFormat Function but this seems to create a knock-on effect that if the date is “clear” (see below, I’m not sure if “clear” is necessarily the same as NULL).that it creates an invalid date.
(I don’t know what TB stores in a date field if the value entered from the date widget is “CLEAR” value but I suspect it may not be null)?
This may just be a MAKE issue, as all I need is a condition to run the dateformula when not empty or clear but I’ve exhausted everything I can think of so far…
The only workaround I’ve found is to copy the date field into a text field in TB and pass that to MAKE when copying a date value, not very elegant…