please help me to get month

system · August 13, 2012, 1:58am

i have a datatable and a field date.
i want to get month from that file
such as this picture i had attach
please help me

ppc0312 (BOB member since 2012-08-13)

system · August 13, 2012, 2:40am

Is the field “denngay” date type?

cpmohanraj (BOB member since 2002-09-23)

system · August 13, 2012, 3:09am

field “denngay” type nvarchar(50).

ppc0312 (BOB member since 2012-08-13)

system · August 13, 2012, 3:16am

You need to convert that to date using Date function and then continue to use your formula on top the date field

cpmohanraj (BOB member since 2002-09-23)

system · August 13, 2012, 3:56am

i had to try convert to type of date
But the error has occur.

ppc0312 (BOB member since 2012-08-13)

system · August 13, 2012, 4:08am

You should use the “Date” function and pass three parameters YYYY, MM & DD.

It will be something like

Month(Date(YYYY, MM, DD))

You may need to create three different variables for YYYY, MM & DD from the field “denngay”

cpmohanraj (BOB member since 2002-09-23)

system · August 13, 2012, 4:58am

thanks for support. but i think that it begin to make me difficult.
I dont know to declare 3 variables for type of date for it run.
you can for me example.
(my field’s DenNgay is format: dd/mm/yyyy 00:00:00)

ppc0312 (BOB member since 2012-08-13)

system · August 13, 2012, 9:33am

Mid(field,4,2)

anil.ganga1 (BOB member since 2007-07-04)