Make Date Time from two fields?

[mikecrengland]

Hello All -

I'm trying to combine a date field and a time field into a timestamp field.

The original data comes from an AS400 and is formatted as integers. My attempt failed...  My script looks like:

LOAD

  MoveNumber

  ,Timestamp(ScheduledEarliest & ScheduledEarliestTime) AS ScheduledEarliestDateTime

  ,ScheduledEarliest

  ,ScheduledEarliestTime

;

LOAD

  Text(MoveNumber) AS MoveNumber

  ,MakeDate(Left(ScheduledEarliest,4),Right(Left(ScheduledEarliest,6),2),Right(ScheduledEarliest,2)) AS ScheduledEarliest

  ,MakeTime(Left(Right('0000' & ScheduledEarliestTime,4),2),Right(Right('0000' & ScheduledEarliestTime,4),2)) AS ScheduledEarliestTime

;

LOAD

  Text(MOVENUMBER) AS MoveNumber

  ,SCHEDULEDEARLIEST AS ScheduledEarliest

  ,SCHEDULEDEARLIESTTIME AS ScheduledEarliestTime

;

Any thoughts on where I messed up?

Thanks,

mike

[sunny_talwar]

How does

SCHEDULEDEARLIEST and

SCHEDULEDEARLIESTTIME

look in there rawest form?

[sunny_talwar · Accepted solution]

Also, I would do something like this:

Intstead of &

Timestamp(ScheduledEarliest & ScheduledEarliestTime) AS ScheduledEarliestDateTime

I would use  +

Timestamp(ScheduledEarliest + ScheduledEarliestTime) AS ScheduledEarliestDateTime

[mikecrengland]

They are.

SCHEDULEDEARLIEST might look like 20160214

and

SCHEDULEDEARLIESTTIME might look like 734 (7:34 AM

[mikecrengland]

That did it!!

Thank you!!

[sunny_talwar]

Sweet