Skip to main content

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.

 

 

 

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.

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.

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') 

Reply


Terms & ConditionsCookie settings