Dealing with Time Stamp on Date Time Prompts.

Wednesday, December 9, 2015

Tags: business objects, date time, prompt, sap, time stamp, web intelligence

When you are dealing with the date time prompts, you may most likely want to remove the time stamp.

Below is an example where I have removed the time stamp from the prompt to display on the report:

FormatDate (ToDate (UserResponse ("PROMPT NAME"); ""); "dd/MM/yyyy")

Here, the important point is that you need to convert to prompt into date first becauseĀ UserResponseĀ returns string value.

After that you can format the returned value into date as you like.

© 2024 -