Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have one date field like below.
Date
201701
201702
201703
.
.
.
.
201712
it showing like that i need creating the month field.in that i want show only months.
Thanks
daisy
num(right(Date,2)) as Month
load Month(Date#(Date,'YYYYMM')) as month