Need one Year Fled from 2 dates

[suresh_qv50]

Hi Team,

I have an Requirement,

we have 2 table, from one table getting Issued date--> derived Year from Issued date

From Another table we have Expiry date --> Derived Year from that date.

Its like a debit card, Now we nee to show in UI

When i select one Year in List box, we need How many cards issued in that year & How many are expired.(We need only one year field list box instead of 2)

In same aspect Month Wise too

Regards

suresh

[veeranj]

Hi Suresh,

Try concatenating two Date Fields and add flags like ' Issued' and 'Expired' and use these flags to count  .

Regards,

Anjee

[Gysbert_Wassenaar]

See this blog post: Canonical Date

[ganeshsvm]

Hi,

Post some sample data in XL.

Regards,

Ganesh

[suresh_qv50]

Hi Please find the sample data

[ganeshsvm]

Hi Suresh,

Canonical date is the best solution for you data, as posted by  gwassenaar‌.

Regards,

Ganesh