cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

assign formatted date to date time picker

assign formatted date to date time picker

Hi, How can I assign the formatted date to Date time picker? because it converts the date to string format and doesn't allow me to bind to the date time picker. Please provide a solution for this.

 

I tried to assign the following query but I am not able to

select CONVERT(varchar(12), CAST(getdate() as date), 107)

 

Thanks,

Shalini V.

2 REPLIES 2

Re: assign formatted date to date time picker

Hi @svisveswaraiya-.

 

The DateTime picker is expecting a Date Time type.  Is there a reason you're trying to convert it to a string first?

 

Regards.

 

--Sharon

Re: assign formatted date to date time picker

Hi @slangley ,

I am trying to convert it because I want it to be in the MM/DD/YYYY format of previous day's date.