Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 date fields loading from Excel :
Assign Dates:
08/12/2019 10:56 AM
this is loaded as
Timestamp(Timestamp#([Assign Date], 'MM/DD/YYYY hh:mm TT') ) AS [Assign Date],
Due Date
43604
The Due Date is automatically recognized as a date field in Date Picker extension as a date field but the other is not.
I tried various formats with Date () and floor () but timestamp dates 09/24/2018 07:18 AM are not being detected by the Date Picker.
Any suggestions ?
Try making your "TT" a lower case "tt". Check out the formatting standards here.