Forum Discussion
Days Presents between two Dates- Power Query
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
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)))
)
2 Replies
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)))
)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))