Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
5 years ago
Solved

Date from text

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.

  • Managed to find a solution: 

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

     

1 Reply

  • mb0307's avatar
    mb0307
    Responsive Resident

    Managed to find a solution: 

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