Compare a date/time field and create a new column from results

[gcongrove]

Hello,

So i have the below table that lists the name of an application, the time it faulted, and the time of the next reboot.  I need to compare the Faulttime and BootStart fields and create a new column that has a result of "Before" or "after"

I need to determine if the reboot (bootstart) happened "before" or "after" the application crash (Faulttime).

can someone help with the code to create this kind of column?

thank you!

FaultApp	FaultTime	BootStart
luservice.exe	3/30/2020 3:10:52	3/30/2020 3:10:43
luservice.exe	3/30/2020 11:13:31	3/30/2020 11:13:08
winlab32.exe	3/31/2020 0:31:32	3/31/2020 0:33:06
luservice.exe	3/31/2020 1:34:55	3/31/2020 1:34:49
luservice.exe	3/31/2020 1:37:45	3/31/2020 1:37:21

[camargos88]

Hi @gcongrove ,

Try it:

Did I answer your question? Mark my post as a solution!
Ricardo

[gcongrove]

This works great, and was simpler than I thought it would be.

Thank you.