select the date number

[#1]

hi, I want to return the value of D in  M/D/YY format. pls help me

[MK_QSL]

Considering that you have D as Day

=Date(MakeDate(Year(Today()),Month(Today()),Day),'M/D/YY')

[maternmi]

Hi Dushan,

I guess you you have a date field as DD/MM/YYYY and would like to change it to M/D/YY. If not pleaec precise your question.

Try this:

anytablename:

laod

    date(datefiled, 'M/D/YY')

resident

    Name of table which consist the date field

[#4]

hi

try this

Date(Date#(datefield,'M/D/YY'),'D')

[#5]

my problem in as an example i have a date 1/12/2013 so i want to get only 1 as the date. how can i get only D filed in M/D/YYYY format

[maternmi]

Try this:

Day(datefield)

[jagan]

Hi,

Try like this

=Day(DateDimensionName)

OR

=Date(DateDimensionName, 'D')

Hope this helps you.

Regards,

Jagan.