Enabling date Input parameter to allow mmdd input but display as dd/mm/yyyy

• Weegee2017

  SSC Eights!

  Points: 994

  More actions

  November 30, 2020 at 3:50 pm

  #3815191

  Hi there

  I have an SSRS Report with various input parameters

  Now one of these is a date field which we want to format to mmdd format  but as the user

  tabs out of it, it will then snap back into dd/mm/yyyy format.

  For example , 1130 would be entered by the user but then it would format to 30/11/2020

  I know you can use the expression

  Format(Fields!ModifiedDate.Value,"dd/MM/yyyy")

   

  Attached are screenshots of what I want to do

  Attachments:

  You must be logged in to view attached files.

• Jo Pattyn

  SSC-Dedicated

  Points: 32344

  More actions

  December 1, 2020 at 1:32 pm

  #3815538

  Have it as a text parameter instead of datetime? Use a second internal parameter to convert the text to datetime?