Problem Date

[pgalvezt]

Hello, I'm having problem with the format date I have this in my script:

MonthName(FieldName)-1 as Month,

MonthName(Date(FieldName,'MMM-YY'))-31 as Period,

But Oct appear like as number

Thanks!

[pgalvezt]

Any Help!

Thanks!

[regowins]

What is the source format of the date? I am guessing you have already tired to format the date on the UI side using the number tab.

[MayilVahanan]

Hi

Try like this

Month(DateFieldName) as Month

If you use MonthName(DateFieldName)-1 gives number..

So please use Month() or MonthName() function

Hope that helps