compare date periods

[Anonymous]

Hi All,

My table 1 and Table 2 has (date with timestamp). i need to compare if the sales happen between particular period

eg table 1 = 01/01/2020 12:47(+3 or -3) need to compare in table 2  01/01/2020 12:44 and  01/01/2020 12:50

[amitchandak · Accepted solution]

You want to compare and populate some value. What is the outcome of this comparison? Please explain with an example. Also share some data

[Anonymous]

@amitchandak Thanks much in advance sir,

https://1drv.ms/u/s!ApPgrUdbr1NBbT4-UdfcQufC8Iw?e=SWehbd

if i select any col and walkin from line

my sales,transaction should split based on hour,day so on

as of now day is coming correct sales=140 and walkin=40 and transaction=52,but line should not be extended, hour wise how to do i dnt have any ideal. please please help

[amitchandak]

Need to use common timestamp table.

[Anonymous]

Yes its working now. Thanks for all your support