Hi All, I have a question regarding datetext function...If I supply a

Two things to check--
1) Are you just testing in the expression editor? I've experienced multiple date inputs have the last date dropped before, so I would retest it with your real data.
2) If the 6th month is being displayed as the 5th month, check your user preferred calendar. Depending on whre the date is read from it may be converted to/from GMT and the hour shift may be placing 6/1 as 5/31

No it is dropping off 6th month...

sorry disregard my comment above...its converting 6/1 to 5/31...i didn't understand what you meant by user preferred calendar?

my working calendar is UTC-5:00 Eastern Time(America/New_York)....so that shouldn't do anything to it....

The default time of a date is right on the line of midnight. It sounds like it is taking in 6/1 12:00am and subtracts 5 hours to reach 5/31 7pm. Try something like datetext(gmt(ri!myDate),.... )

Jesse is correct and the workaround he provides (datetext(gmt(ri!date),"MMM dd yy")) is the correct one. This is a known issue in the product at this time.

If i enclose the dates inside gmt function i am getting the following output: 000/2014, 000/2014,....etc

This is the code:

local!monthYears: apply(fn!datetext, apply(fn!gmt, local!list), "mmm/yyyy")

The function text gets me the perfect output...thanks to jesse..