Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.