Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Not sure, but try this
Date(Floor(TimeStamp#([Date], 'MM/DD/YYYY hh:mm TT'))) as [Date]
Not sure, but try this
Date(Floor(TimeStamp#([Date], 'MM/DD/YYYY hh:mm TT'))) as [Date]
Yes ! It worked ! 🙂