Forum Discussion
compare date periods
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
You want to compare and populate some value. What is the outcome of this comparison? Please explain with an example. Also share some data
4 Replies
- amitchandak
Super User
You want to compare and populate some value. What is the outcome of this comparison? Please explain with an example. Also share some data
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.