Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DateTime and Timezone

Greetings all.

First, of all, I am working in Business Logic 11.5. I have a txt file sitting on a server (the server is in the Eastern Time Zone and DOES observer Daylight Saving Time) GMT-4 during the summer, GMT-5 during the winter.

My MII server is in the Easter Time Zone and DOES NOT observe Daylight Saving Time GMT-5 all year round.

I am using a GetFileList Action block to find out the Date (date node coming back is DateModified).

<h4>The date coming back shows it's timezone as GMT-5</h4>

(I'm guessing from the Mii server) when I do a

datefromxmlformat( GetFileList.FileList{/Rowsets/Rowset/Row/Date}, "MM/dd/yyyy HH:mm:ss z")

)

I'd like to subtrack 5 hours - I know dateaddhours(datetime, -5) - and have it return that that the timezone is now GMT-0 - that's the reason to subtract 5 -for Eastern TimeZone

<h4>ITEM 1- but can't figure out how to get the Time Zone to change. </h4>

<h4>ITEM 2 - The Sample output for the action shows 7 Nodes coming back I only receive 5 of them</h4>

This is mostly a Curiousity Question not a needed item

<Row>
  <Name></Name> 
  <Date>This is really ModifiedDate</Date> 
  <LastWriteDate></LastWriteDate>
  <LastAccessDate></LastAccessDate>
  <Size></Size> 
  <ReadOnly></ReadOnly> 
  <FullPath></FullPath> 
</Row>

I only get back

<Row>
  <Name></Name> 
  <Date>This is really ModifiedDate</Date> 
  <Size></Size> 
  <ReadOnly></ReadOnly> 
  <FullPath></FullPath> 
</Row>

<h4>Is there anyway to get the remaining 2 nodes?</h4>

Edited by: Dennis West on Sep 8, 2008 10:33 PM

Not what you were looking for? View more on this topic or Ask a question