You are viewing limited content. For full access, please sign in.

Question

Question

Date value of 0 in For Each Entry

asked on November 18, 2021

I'm searching for and then iterating through a large number of documents in order to rename them. One of the things I need to do is stick a formatted date on the end of the file name.

To speed things up, I'm pulling back fields as part of the search.

I noticed that for documents with no date, rather than remaining blank at the end--as has long been the case--I'm getting a 0. Even after a conditional sequence that checks if the date is empty, empty dates come through as a zero.

So, I modified the condition to also not equal 0. It still ran the contained logic when the date was missing (showing as zero), but then threw an error when there was an actual date value for trying to evaluate a date as an integer.

Seems like a bug of some sort.

 

 

 

 

 

0 0

Replies

replied on November 18, 2021

Hey @████████  can I get your eye on this?

0 0
replied on November 18, 2021

@████████?

0 0
replied on November 19, 2021

@████████

Miruna figured out that your issue stems from an ancient Workflow bug we somewhat recently discovered (WF bug ID 279626). It's related to a data type casting issue between Int32 and DateTime. It's a bit tricky to resolve and scheduled to be fixed... eventually. Not next release. As a workaround, we recommend breaking up your search to look for entries with non-empty dates separately.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.