need a bit of help with SQL I need to know that the createddate is between friday at 6:00 pm and sunday at 6:00 pm It seems like changing to_char would work but I cant make the between statement work

are you doing this in a search

yes

you probably would have better luck creating 2 Date objects representing the 2 times and using the within filter operator

good idea

SuiteAnswers 35451 may help you out in parsing out the day and time