Jump to content
  • 0

Day Of The Week


Master
 Share

Question

6 answers to this question

Recommended Posts

  • 0

I've tried the above but i still get an error in formula, i'm trying to take a date (Uk +EU Format) and turn it into a day of the week, if the date is above 12 (16/09/2016) I get an error in formula, below twelve works, so this seems to be an issue with EU to US date format conversion. Normally this would be resolved via changing the setting something like:

SET DATEFORMAT DMY
or
SET LANGUAGE BRITISH

But these don't work either any other ideas?

Link to comment
Share on other sites

  • 0
50 minutes ago, scribblemilk said:

I've tried the above but i still get an error in formula, i'm trying to take a date (Uk +EU Format) and turn it into a day of the week, if the date is above 12 (16/09/2016) I get an error in formula, below twelve works, so this seems to be an issue with EU to US date format conversion. Normally this would be resolved via changing the setting something like:

SET DATEFORMAT DMY
or
SET LANGUAGE BRITISH

But these don't work either any other ideas?

Hi scribblemilk,

I see your point. I had the same issue and I resolved it with sql query, which I have provided in my previous reply.

I made a "small" copy of my report. You may check it:

https://c1ect709.caspio.com/dp.asp?AppKey=4325400009a78ab2abf44ee2b5d5

 

Enter 23/09/2016 or 19/09/2016 in the search field.

Can you show your sql query?

Link to comment
Share on other sites

  • 0
18 hours ago, Mathilda said:

Hi scribblemilk,

I see your point. I had the same issue and I resolved it with sql query, which I have provided in my previous reply.

I made a "small" copy of my report. You may check it:

https://c1ect709.caspio.com/dp.asp?AppKey=4325400009a78ab2abf44ee2b5d5

 

Enter 23/09/2016 or 19/09/2016 in the search field.

Can you show your sql query?

My SQL is simply that a one liner:

SELECT DATENAME(dw,'[@Date]')

'Date' is a passed parameter and I simply want to reformat into into a day of the week, I have a localisation of English (UK) to allow for EU format date entry much like your example. Your example seems to work for the dates you suggest but not others (no records) is returned.

 

I've tried the below but I still get a ERROR in FORMULA message, am I missing something?

SELECT DATENAME(dw, CAST('[@Date]' AS DATETIME))

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...