Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day everyone
My Date format is in this format: YYYY/MM/DD hr/mm/ss
I just
LOAD date(floor("Date"),'YYYY/MM/DD', 'DD/MM/YYY') as [Project Date],
asst as [Project asst] ,
Community as [Project Community],
"Project Status";
SQL SELECT "Date",
OML,
Community,
"Project Status"
FROM CRD.dbo."'Complete Progress'";
I got this YYYY/MM/DD but my desired format is DD/MM/YYYY
I used this
LOAD date(date#(floor("Date"),'YYYY/MM/DD') as [Project Date],
asst as [Project asst] ,
Community as [Project Community],
"Project Status";
SQL SELECT "Date",
OML,
Community,
"Project Status"
FROM CRD.dbo."'Complete Progress'";
but it wasn't successful
Regards
Akpofure
May be this
LOAD Date(Floor("Date"), 'DD/MM/YYYY') as [Project Date],
asst as [Project asst] ,
Community as [Project Community],
"Project Status";
SQL SELECT "Date",
OML,
Community,
"Project Status"
FROM CRD.dbo."'Complete Progress'";
May be this
LOAD Date(Floor("Date"), 'DD/MM/YYYY') as [Project Date],
asst as [Project asst] ,
Community as [Project Community],
"Project Status";
SQL SELECT "Date",
OML,
Community,
"Project Status"
FROM CRD.dbo."'Complete Progress'";
Thank you Sunny