Date parameter format

Date parameter format

Posted by: ian on 12 May 2023, 6:19 am EST

• 

  ian

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 May 2023, 6:19 am EST

  The display of selected value in a date parameter does not seem to be respecting system locale values and is always displayed as US format (mm/dd/yyyy). I am in the UK and locale is set to dd/mm/yyyy

  Is there any way to respect these locale settings?

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2023, 3:19 am EST

  Hi Ian,

  Currently, this is not possible with ActiveReportsJS v4.0.1 however, we are planning to release this as a feature in ActiveReportsJS v4.1.0.

  I would suggest you check once when ActiveReportsJS v4.1.0 is released. [ARJ-4830].

  Regards,
  
  Anand

• 

  paul.empett

  • Post Options:
  • Link
    Copy

  Posted 7 September 2023, 12:47 am EST

  Has this now been fixed? I’ve downloaded the latest v4.1.0 version but I still can’t see how to change this to dd/mm/yyyy.
  
  Also, even if I change the date format to YYYY/MM/DD - it is still passed to a (graphql) query as MM/DD/YYYY HH:MM:SS.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 11 September 2023, 2:37 am EST

  Hi Paul,

  You can set the parameter’s Date format by setting the format in the Parameter’s ‘Format’ property (see attached image).

  However, please note this format only applies to the UI of the parameter and not to the reporting logic. To change the default date format in your report you can change the ‘Language’ property of your report to ‘English - United Kingdom’ (see attached image) and it will then use the DateTime format for the specified locale.

  Please find attached a sample report implementing the same.

  Regards,
  
  Anand

  Sample.zip