I have a table with 2 parts data- Date/Text/Value 1 and 2
How can I use tools to copy Value1 to Value2 for rows where the Date2 and Date1 in one line have same month-year and leave the other cells of Value2 empty?
Date1 | Text1 | Value1 | Date2 | Text2 | value2 ( to copy value1) |
2023/2/4 | abc | 123 | 2023/4/4 | nrf | |
2023/3/8 | cdf | 222 | 2023/5/8 | ekrhkjr | |
2023/4/9 | 1bh | 234 | 2023/6/9 | kkl | |
2023/5/3 | igi;l | 780 | 2023/6/3 | jkjkhfu | |
2023/5/15 | njfi | 8897 | 2023/7/15 | dkw | |
2023/7/3 | khfdljg | 1233 | 2023/7/25 | pwer | khfdljg |
2023/7/9 | ggre | 2423 | 2023/8/3 | fjh | |
2023/8/5 | vfff | 687 | 2023/8/12 | ue | vfff |
2023/9/1 | jhrt | 878 | 2023/8/22 | mcd |
Hi, @Shaopingfu
FYI.
1- From [Text1] :
IIF(DateTimeParse([Date1],'%Y-%m') = DateTimeParse([Date2],'%Y-%m'), [Text1], Null())
2- From [Value1] :
IIF(DateTimeParse([Date1],'%Y-%m') = DateTimeParse([Date2],'%Y-%m'), [Value1], Null())
@Shaopingfu One way of doing this