Can I use the same data search for several date fields?

[Anonymous]

Hi all,

I have a xls sheet when 4 weeks e.g

Week for drafting

Week for review

Week for correction

Week for approval

Can I create a week field and use the same week field to search in all of the 4 weeks in the xls?

Example if I enter week 33 then my table list would list all entries that matches week 33 for either drafting, reviewing, correction or approval?

I tried to associate all the weeks with e.g. WeekNumber but gets an error

Any good ideas?

Thanks

Peter

[sunny_talwar]

You need to look at Canonical Calendar for your requirement. Have a look here: Canonical Date

[Anonymous]

Beautiful thanks, I'll have a look.