Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have been trying to remove Timestamp from Date field with following syntax
Date(OVESCO_ADD_DATE, 'MM/DD/YYYY') As OVESCO_ADD_DATE,
DATE(FLOOR(Timestamp#(OVESCO_ADD_DATE)),'MM/DD/YYYY') As OVESCO_ADD_DATE,
Date(Floor(TimeStamp#(OVESCO_ADD_DATE))) As OVESCO_ADD_DATE,
Date(TimeStamp#(OVESCO_ADD_DATE,'MM/DD/YYYY HH:MM:SS'),'MM/DD/YYYY') As OVESCO_ADD_DATE,
Date(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS'),'MM/DD/YYYY') as OVESCO_ADD_DATE,
Result is either blank column or duplicate values(MM/DD/YYYY format) in List box.
All I want is this date value in MM/DD/YYYY format
Thanks
Satish
Use floor() like:
Date(floor(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,
You need to add the Floor function here
Date(Floor(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,
or use DayName() function
DayName(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')) as OVESCO_ADD_DATE,
Hi Sunny/ Tresesco
I appreciate your reply.
But with both suggestion this date is still blank(null)
Try this
Date(Floor(Date#(OVESCO_ADD_DATE,'DD/MMM/YYYY HH:mm:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,
Hi Sunny/ Tresesco
Still issue as blank column.
Thanks
What is the exact format for OVESCO_ADD_DATE?