cancel
Showing results for 
Search instead for 
Did you mean: 

How do I query using a Date field?

Former Member
0 Kudos

Can anyone tell me the best way to do the following:

I have a database that contains a timestamp field (the format looks like this: 2006-12-04 13:45:34:0). I want the user to be able to input a date, and I will then insert that date into an SQL statement to output the information for that date shown.

I have a datepicker control that I am using on the input form, then that date should be matched up to the timestamped date in the databse. I'm not sure exactly how to do this, since I am a Visual Composer newbie.

If anybody has any ideas I would love to hear them! Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Use a formula for reformatting your date. Here are some fomulas for date and time

https://wiki.sdn.sap.com/wiki/display/VC/DateandTime+Formats

Former Member
0 Kudos

Thanks, I used that in combination with some SQL statements and it works!

Answers (0)