Forum Discussion
mb0307
5 years agoResponsive Resident
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
- mb0307Responsive Resident
Managed to find a solution:
Source = {Number.From(Date.FromText(#"Start Date"))..Number.From(Date.FromText(#"End Date"))}