Desktop productivity for business analysts and programmers

Date Formatted Not Showing

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

Date Formatted Not Showing

The column date is in this format:  "30AUG2001:15:59:54.970"

The syntax:

t1.AccountCreated >="01JAN2014:00:00:00.000"d and t1.AccountCreated <="01DEC2014:00:00:00.000"d

is valid but no data appear.  It just gave me a blank screen.  What did I do wrong?

Thanks


Accepted Solutions
Solution
‎02-20-2015 06:12 PM
Super User
Posts: 19,194

Re: Date Formatted Not Showing

It's valid, but not what you intend, use DT to specify a Datetime constant not D.

Try the following:

t1.AccountCreated >="01JAN2014:00:00:00.000"dt and t1.AccountCreated <="01DEC2014:00:00:00.000"dt

View solution in original post


All Replies
Solution
‎02-20-2015 06:12 PM
Super User
Posts: 19,194

Re: Date Formatted Not Showing

It's valid, but not what you intend, use DT to specify a Datetime constant not D.

Try the following:

t1.AccountCreated >="01JAN2014:00:00:00.000"dt and t1.AccountCreated <="01DEC2014:00:00:00.000"dt

Frequent Contributor
Posts: 104

Re: Date Formatted Not Showing

Thank you. It worked!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 301 views
  • 0 likes
  • 2 in conversation