Can you use Julian date to reference days of week?

[Pharmer]

Is there a way to write a query so create a calc field with the day of day, based in Julian dates. I can set P7 to display windows long-date ("Monday, November 21, 2005"), but QBE won't allow "Monday.." Or is there a better way?

 

[TonyMcGuire]

Regardless of what it may display as, the underlying value is a date (longint, actually).

What is it you need to do, exactly?



Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[Pharmer]

I am tracking workload statistics. I receive an ascii file with a timestamp date. I want to parse the days of week from this information, and count the number of transactions per day of week (Sunday, Monday, etc.).

 

[TonyMcGuire]

You may be able to do this direct with SQL; not sure.

Not with QBE though.

You may be able to use a criteria table that has the date linked in the query to your field, and a second field that is the Day of Week for each date. Then use the criteria table in your query to get what you need.



Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.