To everyone, thanks! I can get what I need from what Scott passed along..thanks!
Steve On 4/4/03 3:33 PM, "Scott Cadillac" <[EMAIL PROTECTED]> wrote: > Hi Steve, > > Use the FORMAT attribute to extract the month or any component of a date. > > <@CURRENTDATE FORMAT="datetime:%m"> > > Then Something like: > > Date >= '01/<@CURRENTDATE FORMAT="datetime:%m">/<@CURRENTDATE > FORMAT="datetime:%Y">' > > AND > > Date < '01/<@CALC EXPR='<@CURRENTDATE FORMAT="datetime:%m"> + > 1'>/<@CURRENTDATE FORMAT="datetime:%Y">' > > Of course you may need to compensate for when you are in December, because > 12 + 1 needs to equal 1 with an incremented year - follow me? > > You can also get creative with the FORMAT attribute and do stuff like: > > <@CURRENTTIMESTAMP FORMAT="datetime:01-%m-1980 02:00:00 am"> > which will return: > 01-04-1980 02:00:00 am everyday this month, but next month it will say: > 01-05-1980 02:00:00 am > > The following is copied from the Witango Help files, which shows what you > can get from a Date Time string > > %a ~ abbreviated weekday name > %A ~ full weekday name > %b ~ abbreviated month name > %B ~ full month name > %c ~ local date and time representation > %d ~ day of month (01-31) > %H ~ hour (24 hour clock) > %I ~ hour (12 hour clock) > %j ~ day of the year (001-366) > %m ~ month (01-12) > %M ~ minute (00-59) > %p ~ local equivalent of AM or PM > %S ~ second (00-59) > %U ~ week number of the year (Sunday= first day of week) (00-53) > %w ~ weekday (0-6, Sunday is zero) > %W ~ week number of the year (Monday = first day of week) (00-53) > %x ~ local date representation > %X ~ local time representation > %y ~ year without century (00-99) > %Y ~ year with century > %% ~ % sign > > Hope this helps. Cheers....... > > Scott Cadillac, > Witango.org - http://witango.org > 403-281-6090 - [EMAIL PROTECTED] > -- > Information for the Witango Developer Community > --------------------- > > XML-Extranet - http://xml-extra.net > 403-281-6090 - [EMAIL PROTECTED] > -- > Well-formed Development (for hire) > --------------------- > > > ----- Original Message ----- > From: "Steve Campbell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, April 04, 2003 2:14 PM > Subject: Re: Witango-Talk: Search Action-only month > > >> Okay >> So you are saying, to start my coding to determine the month I am in.I can >> use the substring code you mentioned, correct? >> >> Steve >> >> >> >> On 4/4/03 3:00 PM, "Atrix Wolfe" <[EMAIL PROTECTED]> wrote: >> >>> well, you can do this to get the current month in 00 format: >>> >>> <@substring str="<@currenttimestamp>" start=1 numchars=2> >>> >>> >>> >>> ----- Original Message ----- >>> From: "Steve Campbell" <[EMAIL PROTECTED]> >>> To: <[EMAIL PROTECTED]> >>> Sent: Friday, April 04, 2003 12:46 PM >>> Subject: Re: Witango-Talk: Search Action-only month >>> >>> >>>> I have a search action that is bringing back items in a database. The >>> items >>>> are only a I.D., NewsTitle, Date (in 00/00/0000 for), and news story. >>>> >>>> I only want to bring back the wants that match the current month that > we >>> are >>>> in. I think that I could bring back like March for example, but for the >>>> current month that we are in is what is baffling me. >>>> >>>> Any ideas would be appreciated. >>>> >>>> Thanks >>>> Steve >>>> >>>> >>>> > ________________________________________________________________________ >>>> TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] >>>> with unsubscribe witango-talk in the message body >>>> >>> >>> ________________________________________________________________________ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
