Max Date

[v_jaideep]

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

[rwunderlich]

Can you post the script you tried?

-Rob

[v_jaideep]

Load product_id,DATE(max(Date),'DD-MM-YYYY') as max_date,Category
Resident PRICE
group by product_id,Category;

[rwunderlich]

Your script looks ok. Are you sure your Date values are numeric?

-Rob

[v_jaideep · Accepted solution]

Date(Floor(Date#(Trim(Date), 'YYYY-MM-DD')), 'MM/DD/YYYY') has worked