RE:Date error

[Chanty4u]

hi all,

What wrng in my expression

my date field as

date

2014-may-05

2014-may-06

2014-may-07

2014-may-08

2014-may-09

2014-may-10

=date(MonthsStart( "date"), 'YYYY-MMM')

i want to display date as   :2014-may

how can i get this date.

[marcus_sommer]

Try:

=date(MonthStart(date#(date, 'YYYY-MMM-DD')), 'YYYY-MMM')

- Marcus

[Chanty4u]

thnx marcus,

Its shwng error in expression

PFA

[marcus_sommer · Accepted solution]

You tried it with MonthsStart which requirred more than one parameter and therefore throws an error but you need instead MonthStart - to compare:

MonthsStart

MonthStart

Details to their differences could you find within the help.

- Marcus

[Chanty4u]

thnx marcus.....even though it is nt gvng any value.. as expression is ok .  MonthStart  i used dis

[marcus_sommer]

I have tried this within a textbox and it's working fine:

=date(MonthStart(date#('2014-may-10', 'YYYY-MMM-DD')), 'YYYY-MMM')

- Marcus

[#7]

Hi Suresh,

Can you use the below command in the expression.

=Date(Date#(date,'YYYY-MMM-DD'),'YYYY-MMM')

Thanks,

Sreeman

[Chanty4u]

yeah.. its gvng  correct now but....we are gvng the date manually ryt.......if my data chnges?  how can i ?

[maxgro]

replace with the '2014-may-10' with the field name, in the code below datefield

Source:

load * inline [

datefield

2014-may-05

2014-may-06

2014-may-07

2014-may-08

2014-may-09

2014-may-10

];

load

  datefield,

  date(MonthStart(date#(datefield, 'YYYY-MMM-DD')), 'YYYY-MMM') as newdatefield

Resident Source;

[Chanty4u]

thnx maxgro........if i want to do in frnt end.  how to do this?  without creating new field in bakend?