Days Presents between two Dates- Power Query

[Anonymous]

Hi Experts

I am trying to work out the number days a certain individual | person had consent for between two dates in Power Query... 

My Start Date is in the format (capture_day_id)
20190101 - i cannot change the date to format 01/01/19

My End Date is in the format (expiration_day_id)
20193101 - i cannot change the date to format 31/01/19

List.Dates(
[capture_day_id],
Duration.Days([capture_day_id] - [expiration_day_id]),
#duration(1, 0, 0, 0)
)

But i am getting an error

[amitchandak · Accepted solution]

@Anonymous , Try this for Duration.Days part of your code

Duration.Days(
#date(Number.FromText(Text.Start([capture_day_id],4)), Number.FromText(Text.Middle([capture_day_id],4,2)),Number.FromText(Text.End([capture_day_id],2)))
,
#date(Number.FromText(Text.Start([expiration_day_id],4)), Number.FromText(Text.Middle([expiration_day_id],4,2)),Number.FromText(Text.End([expiration_day_id],2)))
)

[Anonymous]

Hi Amit - getting the following error..

List.Dates(
[capture_day_id],Duration.Days(
#date(Number.FromText(Text.Start([capture_day_id],4)), Number.FromText(Text.Middle([capture_day_id],4,2)),Number.FromText(Text.End([capture_day_id],2)))
,
#date(Number.FromText(Text.Start([expiration_day_id],4)), Number.FromText(Text.Middle([expiration_day_id],4,2)),Number.FromText(Text.End([expiration_day_id],2)))
),

#duration(1, 0, 0, 0))