Skip to main content
Question

Changing Date Format in Quick Report Parameters

  • January 28, 2025
  • 3 replies
  • 117 views
SureshBandara
Sidekick (Partner)
Forum|alt.badge.img+5

Hi everyone,

I have a request from a customer who needs to adjust the date entry format in Quick Report parameters. This is a Crystal-based Quick Report, and they want to enter the date in dd-mm-yyyy format. However, when attached to Quick Report, it prompts for yyyy-mm-dd instead.

 

The report itself is designed to read the date in the required dd-mm-yyyy format, but the Quick Report interface enforces a different format.

Has anyone encountered this issue before? Is there a way to modify the date format for Quick Report parameters inside IFS Application?

Any insights would be greatly appreciated!

Thanks in advance.

 

 

 

S

3 replies

SureshBandara
Sidekick (Partner)
Forum|alt.badge.img+5
  • SureshBandara
  • Author
  • Sidekick (Partner)
  • February 27, 2025

Hi everyone,

Just following up on this. Has anyone encountered a similar issue or found a way to adjust the date format for Quick Report parameters in IFS? Any insights or workarounds would be really helpful.

Thanks.

T
Do Gooder (Customer)
Forum|alt.badge.img+2
  • timsides
  • Do Gooder (Customer)
  • August 28, 2025

I had a similar issue, where they wanted to be able to type in the format MMDDYY. I used a formula to convert the date:

DateTimeValue (Val(RIGHT({?Start_Date},2))+2000,Val(LEFT({?Start_Date},2)),Val(MID({?Start_Date},3,2)))

where Start_Date was the parameter supplied and then used the formula in the Select Expert Record:

({INVENTORY_TRANSACTION_HIST2_A.DATE_TIME_CREATED} = {@STARTDATE} to  {@ENDDATE} + 0.99999999)

This worked fine for me.

T
Do Gooder (Customer)
Forum|alt.badge.img+2
  • timsides
  • Do Gooder (Customer)
  • August 28, 2025

Also, because I found this whilst looking for how to do this in a SQL query Quick Report, and just for noobs like me, TO_TIMESTAMP will convert a string to a DateTime format in IFS Cloud:

co.INVOICE_DATE BETWEEN TO_TIMESTAMP('&Start_Date','MMDDYY') and TO_TIMESTAMP('&End_Date','MMDDYY') 

Terms & ConditionsCookie settingsAccessibility statement