Comments
-
Hi - thanks for the reply. It did not work though. I've attached the formula and what the chart looks like using that formula. I also attached the baseline chart - that has everything except the dropout rate (line). Any help would be greatly appreciated.
-
I think the logic is helpful enough - I think I will have to add some data validation to the front end.
-
Got it - I will look at the case logic - from your last note - I got the following error: "Failed to convert value '22/04/18' from type 'String' to type 'Date'."
-
It keeps erroring out noting "Failed to convert value '005/27/22' from type 'String' to type 'Date'." I then added to your formula DATE( replace(REPLACE( REPLACE(`Interview Scheduled Date`,'/','-') ,'.','-'),'00','0') ) But I got this result, "Failed to convert value '05-27-22' from type 'String' to type 'Date'."
-
Actually the dataset errored out - let me investigate further.
-
DATE( REPLACE( REPLACE(`Interview Scheduled Date`,'-','/') ,'.','/') )
-
Thanks - that worked for most of the entries - but now all the ones that had 22 as the year vs. 2022 still aren't showing up well. So I'm left with the remaining formats: 22-5-20 22-2022-05 I thought about doing a replace on 22 to 2022 but I'm afraid that will impact 5/22/2022 items.
