Match date component of 2 timestamps

[blunckc1]

Hi everyone,

I can't get around this problem and hoping for some help.  My data set contains 2 columns as below.  What I need to do is write an if statement that checks whether the date part of column 1s timestamp matches the date part of column 2s timestamp.

Column 1	Column 2
5/07/2016 9:00	5/07/2016 0:00
23/11/2015 13:00	5/07/2016 0:00
3/09/2015 9:00	5/07/2016 0:00

Expected result would be:

Row 1 = true

Row 2 = false

Row 3 = false

Thanks in advance!

[tamilarasu · Accepted solution]

Hi Carl,

If(SubField([Column 1],' ',1) = SubField([Column 2],' ',1),'True','False')

[blunckc1]

Legend, thanks heaps!