Good Way to Combine Calendar Control Date with Time

  • 18 January 2017
  • 1 reply
  • 2 views

Badge +4

Project's UI requires separate calendar controls for Date and Time.  I want to combine these two values with my call to the sql database.  User selects the date on the date calendar control and then the time on the Time calendar control, then submits smartform (I know one calendar control can do this, but the end-user require two separate fields on the form.

 

I'm thinking the Date Time Operator (Add Hours) would work, but I don't know where to put it, that is, I've tried to set the values, but I'm getting nulls. 

 

How can I combine the two calendar values to send to one DateTime SQL Server field.

 

Taffy


12649iC5F1E7343919BE0C.jpg


1 reply

Badge +8

Hello Taffy_Lewis,


 


I wanted to check in to see if you were able to figure out a solution to this process?  Best possible way would be to concatonate your results from both calendars into a data label using an expression.  You could then use that data label as in input into your create method.


 


Let me know if you require further assistance.


 

Reply