mongodb - I want to assign date to this variable $time

Question

Ex: When system asked to enter a start date, I'm giving the date in this format "2021-02-02T22:30:00.000Z" I have also assign the variable name ($time) in the query also. Please suggest me solution.

$time = Read-Host "Please enter  start date"

$ArgumentList ='--db=rndDB --collection=Messages  --type=csv  --fields Name,Message,Address,Start_date,End_date -q"{\"Start_date\":{\"$gte\":{\"$date\":\"${time}\"},\"$lt\":{\"$date\":\"2021-02-03T22:30:00.000Z\"} } }" --out 
C:\Collection\Date_range.csv'

Write-Output $ArgumentList

Start-Process -FilePath "C:\Program Files\MongoDB\Tools\100\bin\mongoexport.exe" -ArgumentList ' --db=rndDB --collection=Messages  --type=csv  --fields Name,Message,Address,Start_date,End_date -q "{\"Start_date\":{\"$gte\":{\"$date\":\"${time}\"},\"$lt\":{\"$date\":\"2021-02-03T22:30:00.000Z\"} } }" --out C:\Collection\Date_range.csv'

标签： mongodbpowershell