Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Data Source Issue

I got a unique challenge right now

I was putting my data (excel file) from SQL, I got the desired date field results (Month, Quarter and so on)

But for this work, I need to put the data directly from excel sheet... (Same structure, same field with the excel sheet on the SQL connection) but the date fields are missing.

Please see attached files for clarity!!

I can you help me with clues how I will debug it

1 Solution

Accepted Solutions
maheshkuttappa
Creator II
Creator II

Try below


DATE(FLOOR(NUM(DATE#( [CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh:mm:ss' ) )),'MM-DD-YYYY')

View solution in original post

6 Replies
jonas_rezende
Specialist
Specialist

Hi, Akpofure Enughwure.

See if this works in script Excel, color red.

Date(Floor(Timestamp#([CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh:mm:ss')), 'MM/DD/YYYY') as Date



Hope this helps!

akpofureenughwu
Creator III
Creator III
Author

Hello Melo, Just add the # to the expression, No change..

Thank bro.

jonas_rezende
Specialist
Specialist

There also in hh:mm:ss.

akpofureenughwu
Creator III
Creator III
Author

Without the timestamp function, the field produces data like 16.05.2014 23.59.59 (see attached file)

I need to manipulate this 16.05.2014 23.59.59 data to produce day, month, quarter and year field for my report.

Introducing this expression:

Date(Floor(Timestamp#([CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh:mm:ss')), 'MM/DD/YYYY') as Date



I don't get any result for day, monthm quarter ,year and even date.. I have been on this all day....

maheshkuttappa
Creator II
Creator II

Try below


DATE(FLOOR(NUM(DATE#( [CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh:mm:ss' ) )),'MM-DD-YYYY')

akpofureenughwu
Creator III
Creator III
Author

It worked.....

Thanks Jonas...

Why did u use this expression? Can u explain or better still send me a pdf to read up?

I'm grateful

With Regards

Akpofure