If you are unable to create a new account, please email support@bspsoftware.com

 

ParamDisplayValue('BeginDate') and Date Format in Report Author 10.2.1

Started by gosoccer, 16 Jul 2015 11:44:47 AM

Previous topic - Next topic

gosoccer

Hello guys,
I'm displaying the start and end date of a Query. The Start and End Dates are using Date Prompt with the Calendar Selection.

I have to display the date as a part of the report body in the same format as the body of the report. For example, this format is 05/01/2015 (mm/dd/yyyy).

ParamDisplayValue('BeginDate')

Does anybody know how to change the date format to mm/dd/yyyy. I have attached what I have tried but it is not giving me the right format. Please see attached.

Thx so much for your time. I really really appreciate it.



 

TheFrenchGuy

Hi,

in the date format, in order to fill "Date Style", "Date Separator", "Date Ordering" ...
Go to "Pattern" (before the last row in Data format) and Enter 'MM/DD/YYYY' to pattern field



Let me know

gosoccer

Thank you.  :) :)I actually tried that and didn't work. I finally used the following approach:

Report Expression: String2timestamp(paramValue('BeginDate'))
Date Format )Property: See attached.
(Long, /,Month, Day, year,Years:Yes,Months two digits,Day two digits, No Pattern)

Thank you for getting back to me.