XML/XSLT - Pay periods (2 week ranges): how can I identify Week1 vs Week2

cjim.bowlnam

New Member
More details: CSV/XML output, as one of the fields "WeekNumber", should contain either "1" or "2" - but this is dependent on the pay period in question (say Jan1 to Jan15). If Jan1 to Jan8, then WeekNumber=Week1, if Jan9 to Jan15, then WeekNumber=2. There is already existing tokens which can return the pay period start and end - i.e. "PayPeriodStart" returns Jan1, "PayPeriodEnd" returns Jan15. So need the logic to grab either "1" or "2" based on the specific one day in question. Thanks in advance.
 
Top