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

aswinb over 11 years ago

Hi All,

I have a question regarding datetext function...If I supply a list of dates such as 5/31/2014, 5/31/2014, 6/1/2014...it would only display the formats for the month of May. It ignores the 6th month which is the last value supplied. Basically it swallows the last value and doesn't give output for it. Anybody knows how to solve this problem?...

Discussion posts and replies are publicly visible

Parents

0 aswinb over 11 years ago

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")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aswinb over 11 years ago

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")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data