How to group date??

[soha1902]

Hi All,

I am reloading Date from my data but its not grouping Date automatically. Please help me to group this date by Year and Year-Month.

See image:

I attached sample application.

Thanks.

[tresesco · Accepted solution]

try this:

Year(ACTUAL_SHIPMENT_DATE) as Year,

MonthName(ACTUAL_SHIPMENT_DATE) as Year_Month

[ashfaq_haseeb]

try below

Load

Year(ACTUAL_SHIPMENT_DATE) as Year,

year(ACTUAL_SHIPMENT_DATE)&'-'&Month(ACTUAL_SHIPMENT_DATE) as Year_Month

FROM

[Data.QVD]

(qvd)

Regards

ASHFAQ