Forum Discussion
Work out dates between one column on multi rows
In the attached, the same query adapted to a changed column name from Date Notified to createdon.
It produces just short of 900k rows so I've reduced it to one row (to be able to attach it here) which means you'll need to refresh the query to see those rows. it takes a few seconds to generate those rows…
re:"For the first questions i would like the record for 'ceox_newvalue pending information' not to be there for the 10/03."
I've updated the file I attached to previous message, perhaps you can confirm it gives the right dates now.
re: "but I am getting the error on some records when expanding"
I'd really need to see the source data that causes that; I've had a go at guessing what might cause it but without success…
You could replace the existing source data in my file with your error-causing data then save and attach it here.
In the attached, the same query adapted to a changed column name from Date Notified to createdon.
It produces just short of 900k rows so I've reduced it to one row (to be able to attach it here) which means you'll need to refresh the query to see those rows. it takes a few seconds to generate those rows…
Perfect. Works as expected. Thank you so much for your help