assign formatted date to date time picker

[svisveswaraiya]

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.

[slangley]

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

[svisveswaraiya]

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. 

[slangley · Accepted solution]

Hi @svisveswaraiya.

The properties panel for the Date Time Picker widget allow you to select from various formats:

If there isn't an acceptable format available, please provide me with your entities to provide more context around your needs, and I will work on an alternative.

Regards.

--Sharon

[slangley]

Hi @svisveswaraiya-.

If the previous post answered your question, please mark it as the Accepted Solution for the benefit of others on the community.  If you still have questions, please let us know.

Regards.

--Sharon