Date from Timestamp()

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

I have a date field like below in Time stamp format.

How to extract the Date, Quarter and Monthyear from below field.

Thanks in advance

[OmarBenSalem · Accepted solution]

load dateField , (Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,

'Q' & ceil(month(dateField)/3) as Quarter;

load date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;

load * Inline [

timestampField

04/12/2017 11:57

04/12/2017 14:40

07/12/2017 12:58

08/01/2018 17:22

08/11/2017 13:24

10/11/2017 14:25

11/12/2017 16:00

];

Result: