colinr

Comments

Got it thanks.

in is it possible to extract Card data through API? Comment by colinr April 2021
I came up with timestamp(CURRENT_DATE()-1)+(14/24) Let me know if you have anything better!

in Use "Yesterday before 2pm" in a case statement Comment by colinr March 2019
Fantastic Reply! thank you for the walkthrough and that should do it! Will let you knowif I have any questions but looks somewhat straightforward!

in Compare rows and delete if one of the fields do not match Comment by colinr March 2019
Worked a treat. thanks!

in It's easy to remove Duplicates.....How do I KEEP only the Duplicates in a Dataset? Comment by colinr March 2019
Ended up using this to be the 'last Thursday' part. Not sure if ther is a more elegant way for it but it does the job. case when DAYOFWEEK(CURRENT_DATE())=1 then CURRENT_DATE()-3 when DAYOFWEEK(CURRENT_DATE())=2 then CURRENT_DATE()-4 when DAYOFWEEK(CURRENT_DATE())=3 then CURRENT_DATE()-5 when DAYOFWEEK(CURRENT_DATE())=4…

in Days since last Wednesday Comment by colinr December 2018
Nevermind. seemed to work just like this: CONCAT(CURRENT_DATE(),' 12:00:00') Did not need the string part to compare to a date column.

in Create a date field for TODAY at exactly noon Comment by colinr November 2018
Many thanks!

in find max values Comment by colinr December 2017