Dates - XLS Formatting string based on another element value

[robtyketto]

Greetings,

I have a string element called DeliveryDateTime which stores the date/time as dd/mm/yy hh:mm.

I wish to change the hour value based on the value of another string field called "timezone" which holds values as GMT+1, GMT+2 and GMT+3

I know the hour value, hh will always be in positions 10,11 so could use some kind of substring command.

I could perhaps us <xs-If> to check the value of TimeZone but unsure how to manipulate the strings to change their value.

I also know the numeric value in timezone is always in postion 5.

Does anyone have any ideas how to resolve this?

In pseudo code I can only think of an extreme number of if/then to resolve the issue.

Or perhaps I should think about changing DeliveryDateTime and Timezone into type like integers I could work with easier??

I couldt get my head around the timezone element to help me resolve this issue.

Can anyone guide me?
Cheers
Rob

[jkmyoung]

I agree with changing the values into integers temporarily.
Pseudocode:
-Get the number after string GMT. say $shift. select="substring-after(timezone, 'GMT')"
-Get the hour value, say $hour: select="substring(DeliveryDateTime, 10, 2)"
-Add or subtract it to the current hour, add 24, and take the mod of the number 24
($hour - $shift + 24) mod 24

The reason we add 24 to begin with is so we don't end up with a negative number. Even if $hour - $shift is already > 0, we cancel it out with the mod 24.

[robtyketto]

Well Ive decided to look at this and investigate more.

I need to read more about variables and elements but heres some psuedo code(well mixture of pseudo code and xsl code)

<xsl:for-each select="//my:POD/my:Customer">
<xsl:choose>
<xsl:when test ="@xsi:type='NonUKCustomer'">

<xsl:variable name="hour" as="xs:integer(substring(my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDateTime,10,2)"

<xsl:variable name ="seconds" as ="xs:integer(substring(my:PODBatch/my:POD/my:DeliveryInfo/my:DeliveryDateTime,12,3)"

<xsl:variable name="hourdifference" as="xs:integer(substring-after(my:PODBatch/my:POD/my:Customer/my:Timezone,’GMT+’)"

<xsl:Variable name=newhour" as="xs:integer(hour + hourdifference + 24) mod 24./>

<xsl:Variable name "newtime" = newhour + seconds = correct time./>

</xsl:when>
</xsl:choose>


I just need to change it into working code!!!

Thanks
Rob