Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking to get max date from below dataset based on Category and Country. For some reasons I'm getting it as blank(-) when I group by or even just use max(Date). Any other inputs.
Country | Date | Category |
USA | 6/3/2021 | A |
USA | 4/21/2021 | A |
USA | 1/1/2021 | A |
UK | 5/20/2021 | B |
UK | 4/22/2020 | B |
Date(Floor(Date#(Trim(Date), 'YYYY-MM-DD')), 'MM/DD/YYYY') has worked
Can you post the script you tried?
-Rob
Load product_id,DATE(max(Date),'DD-MM-YYYY') as max_date,Category
Resident PRICE
group by product_id,Category;
Your script looks ok. Are you sure your Date values are numeric?
-Rob
Date(Floor(Date#(Trim(Date), 'YYYY-MM-DD')), 'MM/DD/YYYY') has worked