Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
my current max date is 17-aug-2017
if i dont make any selection in month field, then it should default to last full completed month
in my case that is june 2017
else if i make a selection in the month field means then it should be the selected month
below is the if condition I am using but its not working
please suggest.
=IF(len(GetFieldSelections([Calendar Month]) )=0, MONTHEND(AddMonths(today(-1), -1)),[Calendar Month])
Is Jan, Feb, Mar.... your calendar Month field? What is the date field my friend? Did you expect Jun to convert to a date by itself? Use this
Date(If(GetSelectedCount([Calendar Month]) = 0, (MonthStart(Today()) - 1), Max(DateFieldHere)))
Hi Raj,
Can you clearly explain your requirement. Pls!!
Thanks
Harshitha
Hi,
Try this.
IF(GetFieldSelections([Calendar Month])=0, MONTHEND(AddMonths(Max([Calendar Month]), -1)),Max([Calendar Month]))
Regards,
Kaushik Solanki
Hi Kaushik
its not working as expected
Kindly share your application.
Regards,
Kaushik Solanki
What exactly is your goal here? Make a month selection or just save the value in a variable? Would you be able to elaborate a little?
Hi sunny
I want to store this in a variable
=IF(len(GetFieldSelections([Calendar Month]) )=0, MONTHEND(AddMonths(today(-1), -1)),[Calendar Month])
my requirement is
my max date in my app is 17-aug-2017
in my text box with my variable want to see a month, if no selections were made on month list box, then it should show last fully completed month(which is June 2017) in my text box, else selected month need to shown
May be this
Date(If(GetSelectedCount([Calendar Month]) = 0, (MonthStart(Today()) - 1), Max([Calendar Month])))
sunny
When I use this in the text box and select June
its displaying
05/01/1900
Can you show an image of a list box for Calendar Month?