I am trying to determine how to write a formula that will determine the difference between two different date/time. Here is the data I am working with from my files:
PSCrtDate and separate field PSCrtTime both are numbers and I want to combine into one field called PSTiming. I then have XHCrtDate and XHCrtTime both numbers and I want to combine into one field called XHTiming. I then want to create a formula that states if PSTiming <= XHTiming then yes else no.

Can someone help me with this set up.


Appreciate any assistance.

Rose