Challenge #494: Pay Period End Dates

[alexnajm]

Done!

Spoiler

[Carolyn]

Solved! Great challenge, @mkeiffer. I was a little worried there might be something weird where the In/Out dates were in 2 different pay periods, but happy you didn't go too weird :)

Spoiler

[Ruben_Occ]

Spoiler

Using dynamic replace :)

[mkeiffer]

Thanks so much. @Carolyn  and I am glad you liked it. I thought it would be a fun challenge for people as there are a few different approaches that will give the correct answer. 

[chanivan]

Not sure how efficient this be scaled up but it does the job for now

Spoiler

[Qiu]

Completed.

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

Multi-Row Formula Tool
  IF IsEmpty([Row-1:Period_End_Date])
  THEN DateTimeAdd([Period_End_Date],-13,"Day")
  ELSE DateTimeAdd([Row-1:Period_End_Date],1,"Day")
  ENDIF

Generate Rows Tool
  Initialization Expression: [Period_Start_Date]
  Condition Expression:      [Date] <= [Period_End_Date]
  Loop Expression:           DateTimeAdd([Date],1,"Day")

[dkungu]

Interesting challenge with dates

[RWvanLeeuwen]

Here we go!

Spoiler

[annbriceAB]

A fun challenge.