Date Format for Parameter from Workflow

Margaret Montgomery

4 octobre 2022 23:59

We are passing a Startdate and Enddate as parameters gathered from a Workflow into a report. It is used to define the records selected for the report. We'd like to show the date in the MM/dd/yyyy format (no time to be shown). 

In the report, the Parameter Type is set as Date and the Text Format String is set as {0:MM/dd/yyyy}. I've also tried setting the date format in the Expressions Text setting as FormatString('{0:MM/dd/yyyy}',?startDate) as well as the same in the Expressions Visible setting. 

No matter what method we try, the format still continues to be displayed on the report as follows: Wed Jun 01 2022 00:00:00 GMT-0400.

Where do we set the date format to only show MM/dd/yyyy?

Thank you! 

1

• 

  Ali VanSickle

  16 janvier 2023 20:44

  Margaret Montgomery 
  
  Did you get this to work? 
  
  I am also trying to do the same thing; pass dates into a report as parameters from a workflow.

  0

Vous devez vous connecter pour laisser un commentaire.