Date from text

[mb0307]

Hi,

In Power Query, I have a Start Date Query, which is being calculated dynamically in the text format.  Example: 01/06/2020

and I have this code:

Source = {Number.From(#date(Number.FromText(Text.End(#"Start Date",4)),1,1))..Number.From(#date(Number.FromText(Text.End(#"End Date",4)),12,31))}

I want to use Start Date Query as an input in the code above (replacing 'Start Date' and 'End Date').  

Is it possible to do it in the Power Query code above please?

Thank you.

[mb0307 · Accepted solution]

Managed to find a solution: 

 Source = {Number.From(Date.FromText(#"Start Date"))..Number.From(Date.FromText(#"End Date"))}