topic Re: Date function on timestamp - field not recognized by Date Picker extension ? in App Development

Date function on timestamp - field not recognized by Date Picker extension ?

claudialet — Thu, 05 Dec 2019 15:32:26 GMT

Here is the date value in Excel :

06/13/2019 02:35 PM

Here is the auto generated load script :

Timestamp(Timestamp#([Date], 'MM/DD/YYYY hh:mm TT') ) AS [Date]

I am trying to use this in Date Picker but it is not auto detected as a date field even if I format it as 'MM/DD/YYYY' in the properties.

I tried the following but no solution !

Date(Date#([Date ],'MM/DD/YYYY h:mm'),'MM/DD/YYYY')

Date(Date#floor(Timestamp(Timestamp#([Date], 'MM/DD/YYYY hh:mm TT') )) 'MM/DD/YYYY') AS [Date]

Any ideas ?

sunny_talwar — Thu, 05 Dec 2019 17:45:58 GMT

Not sure, but try this

Date(Floor(TimeStamp#([Date], 'MM/DD/YYYY hh:mm TT'))) as [Date]

claudialet — Thu, 05 Dec 2019 18:46:31 GMT

Yes ! It worked ! 🙂