Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HEy,
I have used Month field and used a list box but my months are not coming in Jan-Dec order. They are coming in A-Z order.
What to do , please help.
Thanks
plese check the spelling of 'july'
filed values names should also match in Match()function then only it will reflect the correct order
E.g:
MonthFiled
Jan
Feb
Mar
April
May
June
July
.
.
.
.
.
Then you have to wrrite like
Match(MonthFiled,'Jan','Feb','Mar'.....)
Exactly same as above its case sensitive
Hi,
Also you can write in sorting > Exrpession
=Pick(Match(Monthfield,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec',1,2,3,4,5,6,7,8,9,10,11,12)
try to check the option
Load Order
if not
then use match function
Match(<Month-Field>,'Jan','Feb','Mar',............................)
in sort tab Expression
Hey ,
this doesnot works....
Hey,
MAtch function works but problem is Before jan it is showing July.
I mean:
July,Jan,Feb..... Jun , Aug....Dec
What to do now??
then please check the spell once in your backend make sure that same is there in your expression
may be issue with cap/small letter
HEy,
I didnot get you. What you wana say ??
Hi,
attach some screenshot or some sample data.
Go to Sort Tab
Select Month
Write below in expression =Date#(Month,'MMM')
now you can sort by Numeric Ascending or Descending Order