I need to prompt a user to input the audit time stamp as a date range. I would like the user to utilize the calendar as a prompt input.
End Result:
My Audit Time Stamp is set as a text. I need to covert it to a date.
My user prompt input ...
On the available objects tab in my report it is listed as type TextOn the query panel in my report it is listed as type StringHow do I fix this so that I may set a calendar control type?
Thank you for your prompt response. I don't know how to change the object in the universe. In one of the reports created by my colleague the object "Audit Time Stamp" is set as Date Time. This object is is used in many different reports across my com...
Thank You Amit for your response. Yes, The object is a string. I am getting the below error message. It can't find the object at position 37.I received the error message again when I removed the FormatNumber() but this time at position 24.