IIF or SWITCH Condition to use and how

• sanju2t

  SSC Enthusiast

  Points: 125

  More actions

  September 27, 2012 at 12:46 am

  #268251

  Hi,

  I have a report where countrycode is a paramater and i need to show the date format as dd/MM/yyyy on basis of countrycode. Can someone help me know how can i simplify the statetment for the condition?

  In Pseudo code:

  If countrycode in ("AU", "NZ", "IN", "MAL")

  then

  endDate.Format("dd/MM/yyyy")

  else

  endDate.Format("MM/dd/yyyy")

  end if

  I need to write somewhat the same for my report (.rdl) file.

  Thanks

  Susheel

• crashdan

  SSCommitted

  Points: 1990

  More actions

  September 28, 2012 at 5:58 am

  #1543365

  sanju2t (9/27/2012)

  ---

  Hi,

  I have a report where countrycode is a paramater and i need to show the date format as dd/MM/yyyy on basis of countrycode. Can someone help me know how can i simplify the statetment for the condition?

  In Pseudo code:

  If countrycode in ("AU", "NZ", "IN", "MAL")

  then

  endDate.Format("dd/MM/yyyy")

  else

  endDate.Format("MM/dd/yyyy")

  end if

  I need to write somewhat the same for my report (.rdl) file.

  Thanks

  Susheel

  a case statement is your friend

  case when countrycode in ("AU", "NZ", "IN", "MAL") then convert(varchar(12),[datecolumn],101)

  else convert(varchar(12),[datecolumn],103)

  end

  *code may take some tweaking

• D.DHAMO

  Mr or Mrs. 500

  Points: 506

  More actions

  September 28, 2012 at 6:07 am

  #1543370

  Goto Expressions :

  iif(fields!country.value="","",<field_name>,<field_name>)