Hi,
I am importing multiple items from a CSV file into a collection. I have defined the fields to be able to set 2 fields as DateTime to be able to do calculations.
I have a field called ETA Date that is a DateTime field. not all the items in the collection have a value for this field.
I do a filter collection on another column of the collection. When I opened the new filtered collection, the ETA Date field that were blank values now show 0001-01-01 05:00 AM
When I trying to write this collection to Excel, it is telling me the field value is not valid. I cannot figure out how to get BP to stop putting a value in there and I also cannot figure out how to blank out the values that are 0001* (I tried a calculation field but it will not let me put a blank value or a space since it considers it putting text in a DateTime field).
any of you can help me? I attached screenshots if it can help
thank you in advance!
I am importing multiple items from a CSV file into a collection. I have defined the fields to be able to set 2 fields as DateTime to be able to do calculations.
I have a field called ETA Date that is a DateTime field. not all the items in the collection have a value for this field.
I do a filter collection on another column of the collection. When I opened the new filtered collection, the ETA Date field that were blank values now show 0001-01-01 05:00 AM
When I trying to write this collection to Excel, it is telling me the field value is not valid. I cannot figure out how to get BP to stop putting a value in there and I also cannot figure out how to blank out the values that are 0001* (I tried a calculation field but it will not let me put a blank value or a space since it considers it putting text in a DateTime field).
any of you can help me? I attached screenshots if it can help
thank you in advance!