Skip to content

Instantly share code, notes, and snippets.

@watert
Created August 19, 2013 03:19
Show Gist options
  • Select an option

  • Save watert/6265508 to your computer and use it in GitHub Desktop.

Select an option

Save watert/6265508 to your computer and use it in GitHub Desktop.
between date for mongoose query using
mongoBetweenDate = (date1,date2=false)->
parseDateStr = (date)->
dateStr = date.replace(/-/g,"/")
d = new Date dateStr
d = false if d is "Invalid Date"
d
date1 = parseDateStr date1
where = {}
if date1
where["$gte"] = date1
if date2
d2 = parseDateStr date2
if d2
d2.setDate d2.getDate()+1
where ?= {}
where["$lt"] = d2
else
d2 = (new Date(date1))
d2.setDate date1.getDate()+1
where["$lt"] = d2
where
if "test" in process.argv
d1 = "2013/02/05"
d2 = "2013/05/05"
console.log mongoBetweenDate(d1,d2)
console.log mongoBetweenDate(d1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment