Date entries

Mike Mackinnon

Well Known Member
Does anybody know how to get a date "day"?

Example: Jan 26, 2001 --> I want to isolate the "26"
Feb 3, 2001 --> I want to isolate the "3"

I have tried already to get this but I run into problems because of different date settings on different machines/users (01-01-26 vs. 01/01/26, etc).

I am sure this is something easy but I am currently unable to determine the business function or other requirements to get this to work. Thank you.

Mike MacKinnon
(OW 733, SP11.3 this time)

- One World B733, SP 11.3
- One World Xe B7333, SP 13 Windows NT
 

got_to_love_jde

Reputable Poster
hi mike,
it looks like you use the variable "assignment/expression" in the even rules. highlight your variable in left box and then click on the f(x) button. from there i think you can use the "date_day()" function to insert just the number day into your variable.
i haven't time to try it but it looks pretty straight forward.
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix 1.8 (XE soon)
 
Hi Mike,

To get the day in Tools you must do:

1. Inside an ER Select the Assignment button
2. At the left side select the number variable for the day (Number (2))
3. At the right side select the button f(x)
4. In Advanced Functions box dobleclick DATE FUNCTIONS
5. Dobliclick Date_Day() function
6. In Available Information, select the date variable

That's it

See you

Harold

En Fri, 26 Jan 2001
12:02:48 -0800 (PST) Mike Mackinnon escribió:

> Does anybody know how to get a date "day"?
>
> Example: Jan 26, 2001 --> I want to isolate the "26"
> Feb 3, 2001 --> I want to isolate the "3"
>
> I have tried already to get this but I run into problems because of
> different date settings on different machines/users (01-01-26 vs.
> 01/01/26, etc).
>
> I am sure this is something easy but I am currently unable to determine
> the business function or other requirements to get this to work. Thank
> you.
>
> Mike MacKinnon
> (OW 733, SP11.3 this time)
>
> - One World B733, SP 11.3
> - One World Xe B7333, SP 13 Windows NT
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=4675

>
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>




Harold
B7332, SP11.3, ESU 4605023-4605031
Oracle 8.1.6(8i), NT 4.0 SP6a, C++ SP3
 
Top