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 0...
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
Super User
Super UserYou 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.
Yes its working now. Thanks for all your support