JDE incremental load using CYYDDD field and seperate time file to set Last Modificatied Date

[#1]

I am new to Qlikview and I am having a problem with JDEdwards File because the dont have a datetime stamp. There use two fields. One for the date in a CYYDDD as 110001 being January 01, 2010 and the other field being the time field. I need to join these field to come up with a MAX LastModificatied Date. Does any one have sample code. Thanks Sharon

[#2]

I just came across the same issue and, after some tweaking, have concluded that you can join both JDE fields to make a "timestamp" without converting them to QV dates:

SDUPMJ + SDTDAY/1000000 as Timestamp

I have, however, included the date and time conversion formulas in the attached file in case you need them.