Date Creation

[akpofureenughwu]

Good day everyone. I need help. I need to create date from a field as shown from the attached file. How do I get date, month, quarter from the date availabe in the attached file. Please assist me? Thanks

[sunny_talwar]

I think it would be best if you use CrossTable load to change the MonthYear into rows. Look here on how to do it:

The Crosstable Load

Once you do this, all manipulations will be very easy

[akpofureenughwu]

Cool but can u help me to cross a set of data as a sample for me to execute others. Pls see the attached excel file. Thanks man

[sunny_talwar · Accepted solution]

See if the attached make sense

[akpofureenughwu]

Bravo sir, But can you help me with the day as a field please so I can drill from year to quarter to month to day. Thanks so far man