select a specific month&day for all years

[Scott Ballinger]

This is D3. Date format is US mm-dd-yy.

I can't figure out how to select a specific date (e.g. March 1st) across all years.

When I "select invoices with date eq "03-01-^^" or "03-01-]" I just get 03-01-24. What I want to do is sample all invoices with that date across all years.

Other than creating a basic call dict item, can this be done?

Thanks,

/Scott

[Scott Ballinger]

Funny how describing a problems presents you with the solution.

Julian date! Putting "dj" in attribute 8 and selecting for "61" gets the job done.

[Scott Ballinger]

Arghhh! Except for leap years.

[Wols Lists]

Does D3 have the equivalent of Universe EVAL?

EVAL "OCONV(DATEFIELD, "MMM-DD")" EQ "MAR-01" or something like that.

Cheers,
Wol

[Optimus01010101]

Make 2 new dictionary records, one for DAY and one for MONTH

For DAY, put on attribute 8 the code "DD"

For MONTH, put on attribute 8 the code "DM"

Here's my output in QM in a PICK style account. I had to look up the codes in an old Ultimate manual I have.

LIST CK MONTH DAY ACK_6                                                  Page 1
CK........   Month.....   Day.......   Date......
5100*1604            02           25   02/25/2013
5105*46093           12           14   12/14/2017
5100*1605            02           25   02/25/2013

3 record(s) listed
:SELECT CK WITH DAY EQ "25" AND MONTH EQ "02"
2 record(s) selected to list 0
::LIST CK MONTH DAY ACK_6
LIST CK MONTH DAY ACK_6                                                  Page 1
CK........   Month.....   Day.......   Date......
5100*1604            02           25   02/25/2013
5100*1605            02           25   02/25/2013

2 record(s) listed

[Scott Ballinger]

Yup!!!

Thanks.

[Scott Ballinger]

Unfortunately, I don't think D3 eval works like that, nor do I think oconv(datefield,"mmm-dd") is gonna work in D3 either.

[Christopher Jeune]

Oconv(‘d’,,)?

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/89c7ff65-9a2d-4921-b25e-f6439df47851n%40googlegroups.com.

[Joe Goldthwaite]

I don't have access to a D3 system but since you're getting the julian date by putting "dj" in attribute 8, try putting "d0" and then selecting for "03 Mar". An alternative would be "d0-" and selecting for "03-03".

[jorge jjcsf]

 simple way I think:

2 words in  dict of file

Date                   Rdate

001 A                001 A

...                        ...

...                        ...

007 D2-             007

008                    008 D2-

009 R                009 R

010 8                010 8

as  D3 do select using atrib 8 and format using atrib 7 you can do

Sort/list file with Rdate ="03-02]" Date ....etc.

Best regards

--

[geneb]

Maybe two simple dicts with a month output conversion in one and a day
output conversion in the other? Then you could do "select foo with
month = 3 and with day = 1"

g.



--
Proud owner of F-15C 80-0007
http://www.f15sim.com - The only one of its kind.
http://www.diy-cockpits.org/coll - Go Collimated or Go Home.
Some people collect things for a hobby. Geeks collect hobbies.

ScarletDME - The red hot Data Management Environment
A Multi-Value database for the masses, not the classes.
http://scarlet.deltasoft.com - Get it _today_!

[geneb]

On Tue, 24 Sep 2024, Scott Ballinger wrote:

> Funny how describing a problems presents you with the solution.
> Julian date! Putting "dj" in attribute 8 and selecting for "61" gets the
> job done.
>

\o/

[philippe GRACIA]

hello.

only d0- in att8 of dict

you can try with basic :

print oconv((20723,'d0-') gives you 25-09 ;)

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/alpine.LRH.2.21.2409250718380.568158%40sidewinder.deltasoft.com.

[Christopher Jeune]

What's Day 0?  I was there for Day 10,000

--

You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/89c7ff65-9a2d-4921-b25e-f6439df47851n%40googlegroups.com.

[Eric Means]

Ok. I don't know where juilian was mentioned,  but the original post asked:

"I can't figure out how to select a specific date (e.g. March 1st) across all years."

If the field, aka attribute  stores the the date in standard PICK compatability, then using "DM" and "DD" as correlative codes is the best solution.

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/CACHAbR1QtCthbPS4e-b%2BuaJGw7aj_Tbz%2B0EFOt3DXGMi9ivpNQ%40mail.gmail.com.

[Chris Long]

Jan 1^st, 1968

[Brian Speirs]

Actually, that is day 1. Day 0 is 31 December 1967.

Brian

[Scott Ballinger]

I think "d0" or "d0-" is the simplest solution offered.
Many thanks to phig330 and joe!

/Scott

[Christopher Jeune]

When was Day 10,000?  I don't have a current pick system to run the date command.   TIA!

--

You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/MWHPR04MB0896260B777119F9CB7A8E9AAA6A2%40MWHPR04MB0896.namprd04.prod.outlook.com.

[James A]

>MY.DATE 10000

Internal Pick Days                    : 10000

Default External Pick Date (oconv 'D'): 18 MAY 1995

 

 

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/CACHAbR0JvujrvkPbBr4qLT0M32A6YGed-Of0D%2BeSULRui2-idA%40mail.gmail.com.

[John Lorentz]

Or, as we referred to it, the "Mt. St. Helens virus" (Mt St. Helens' famous eruption was May 18, 1980--a date that many of us in Pacific NW remembered very well).

John

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/SN7PR20MB57690D96355C09CA07D925BAFD6B2%40SN7PR20MB5769.namprd20.prod.outlook.com.