colinr

Overview

Overview
Roles	Member
Badges	4

Posts

Visits

Points

Dec 29, 2017

Join Date

Apr 21, 2021

Last Active

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

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.