You need to sign in to do that
Don't have an account?
Varun Teja
If I select Picklist value date fileds should populate automatically
Can you please help on below criteria.
1) A picklist showing values 2011, 2012 and 2013
2) 2 Date fields (From Date and To Date)
3) When user picks the value in 1st picklist, From and To Date should automatically populate.
Ex: If I select 2011, From Date should be 01/01/2011 and End ddate should be 12/31/2011 automatically populate
If I select 2012, From Date should be 01/01/2012 and End ddate should be 12/31/2012 automatically populate
Thanks In Advance
1) A picklist showing values 2011, 2012 and 2013
2) 2 Date fields (From Date and To Date)
3) When user picks the value in 1st picklist, From and To Date should automatically populate.
Ex: If I select 2011, From Date should be 01/01/2011 and End ddate should be 12/31/2011 automatically populate
If I select 2012, From Date should be 01/01/2012 and End ddate should be 12/31/2012 automatically populate
Thanks In Advance
Create 'From Date' as formula field with return type date.
And use this formula:
CASE(picklist_field__c,
2011 , DATE(2011,01,01) ,
2012, DATE(2012,01,01),
DATE(2013,01,01)
)
Similarly, Create 'To Date' as formula field with return type date.
And use this formula:
CASE(picklist_field__c,
2011 , DATE(2011,12,31) ,
2012, DATE(2012,12,31),
DATE(2013,12,31)
)
Thanks for reply..
I have added in From Date formula field
Getting error " Error: Field Year__c may not be used in this type of formula"
I have picklist as Year__c.
Could you please help me on this.
Can you please show me your formula for From date.
Still Im getting error
Are you creating this as a formula field?