Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
September 10, 2019
Solved

assign formatted date to date time picker

  • September 10, 2019
  • 1 reply
  • 1791 views

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.

Best answer by slangley

Hi @svisveswaraiya_285988.

 

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

 

Date.PNG

 

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

1 reply

S
slangleyCommunity Manager
Community Manager
September 10, 2019

Hi @svisveswaraiya_285988.

 

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

S
svisveswaraiya_2859881-VisitorAuthor
1-Visitor
September 12, 2019

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. 

S
slangleyCommunity ManagerAnswer
Community Manager
September 25, 2019

Hi @svisveswaraiya_285988.

 

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

 

Date.PNG

 

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

Terms & ConditionsCookie settingsAccessibility statement