hard code the date

[nareshthavidishetty]

Hi,

I need to hard code the date as

=if(storeID='017','07/19/2016',date(min(New_A7AIDT),'MM/DD/YYYY')) and it's working fine

But they have intiated two new stores and they want activated date on

storeID = 25,activated date =0 8/4/2016

storeID  = 27 activated date = 08/5/2016

storeID   = 26 activated date = 08/6/2016

How to integrate all these dates in one expression.

Thanks...

[sunny_talwar · Accepted solution]

May be like this:

Pick(Match(storeID, '017', '25', '27', '26') +1, Date(Min(New_A7AIDT),'MM/DD/YYYY'), '07/19/2016', '08/04/2016', '08/05/2016', '08/06/2016')

[nareshthavidishetty]

Hi Sunny,

Small change we don't need the min

date but after using the above logic the date remains same.

Logic used: Pick(Match(A7AACD,'017','25','27','26')+1,Date((New_A7AIDT),'MM/DD/YYYY'),'07/19/2016','08/04/2016','08/05/2016','08/06/2016')

Thanks..

[sunny_talwar]

Not really sure what you are trying to do, can you share a sample or some screenshots?

[nareshthavidishetty]

Hi,

The below logic is working fine when i have tested with an sample data.

But it's not working in my chart.We have converted the century date(1160804) format into normal date format

where,

New_A7AIDT = date(date#(A7AIDT+19000000, 'YYYYMMDD'),'MM/DD/YYYY')

Logic:

Pick(Match(storeID, '017', '25', '27', '26') +1, Date(Min(New_A7AIDT),'MM/DD/YYYY'), '07/19/2016','08/04/2016', '08/05/2016', '08/06/2016')

Thanks..

[nareshthavidishetty]

Hi Sunny,

Issue resolved...great..

My mistake..I need to change location detail instead of '25' need to change '025'.

Thanks...