Replicate number of days with in quarter for two date fields

[pranubitla]

Dear Experts, please see below sample app.

I would like to replicate number of days within Q1  from [Entry Date]  to  [Insite Date]

(Entry date should be in Q1 and Insite date (should be in Q1)  )

please help

[sunny_talwar]

Where are you looking to do this? What is the expected output?

[Kushal_Chawda]

I don't find any entry date in your data

[pranubitla]

I am planning to show number of days from Entry date to Insite date

see the attached screenshot please.

[pranubitla]

Hi Sunny,   I would like to show number of days from Entry date to Insite Date,  example user select Quarter from list box, data from Process2 field ( see edit script line 12) number of days should filtered with in Q1.

hope I am not confusing you.

[pranubitla]

Kaushal, See the entry date highlighted in yellow ColumnC from the attachment

[pranubitla]

see the attached screenshot.

My Actual result vs Expected result.  number of days from Entry date to Insite date

Please help.

[sunny_talwar · Accepted solution]

But which object are we trying to do this in? Or is this something you need across your object? If it is for a specific object, would you be able to mention what are the expected numbers you are looking to get once you make your selection of Q1?

[pranubitla]

Hi Sunny,

I am using this for only one specific object  when I select Q1 I should get only 3 items for Process 2

see attached screenshot please

[sunny_talwar]

Got it, I think what you need here is a Canonical Date