Dealing with Time Stamp on Date Time Prompts.

Wednesday, December 9, 2015

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.