let
FileName=fnGetParameters("TB_PARAMS","FULLFILEPATHNAME"),
FileEncoding=fnGetParameters("TB_PARAMS","FILEENCODING"),
DateDeb=fnGetRangeValue("DATE_DEB"),
DateFin=fnGetRangeValue("DATE_FIN"),
ToDateDateDeb=#date(Date.Year(DateDeb),Date.Month(DateDeb),Date.Day(DateDeb)),
ToDateDateFin=#date(Date.Year(DateFin),Date.Month(DateFin),Date.Day(DateFin)),
Source = Csv.Document(File.Contents(FileName),[Delimiter=";", Columns=null, Encoding=FileEncoding, QuoteStyle=QuoteStyle.None]),
#"En-têtes promus" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Type modifié" = Table.TransformColumnTypes(#"En-têtes promus",{{"date", type date}}),
//#"Lignes filtrées" = Table.SelectRows(#"Type modifié", each [date] >= #date(2005, 1, 1) and [date] <= #date(2010, 12, 31))
#"Lignes filtrées" = Table.SelectRows(#"Type modifié", each [date] >= ToDateDateDeb and [date] <= ToDateDateFin)
in
#"Lignes filtrées"