• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1233
  • Last Modified:

getting a date in mm/dd from DTOC

lcEndLastWeek = DTOC(ldEndLastWeek)

results are 10/31/2010

I want it to be 10/31

waht is the best way for that?

Thanks
0
jaymz69
Asked:
jaymz69
  • 5
  • 4
  • 2
2 Solutions
 
pcelbaCommented:
The best way is:

LEFT(DTOC(ldEndLastWeek), 5)
0
 
tusharkanvindeCommented:
I prefer using month and day functions as DTOC depends on the date setting.

textmerge('<<month(ldEndLastWeek)>>/<<day(ldEndLastWeek)>>')
0
 
CaptainCyrilCommented:
I also go for using Month and Day since you might also have less for days and months less than 10.

? TRANSFORM(MONTH(dDate),'@L 99') + "/" + TRANSFORM(DAY(dDate),'@L 99')

@L Gives you 2 digits with leading zeroes.

In the example above you have 10/31/2010. What is it was 9/31/2010. You would get "9/31/".
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pcelbaCommented:
Captain, have you ever seen DTOC() function returning 9/31/2010 ?  :-)))

0
 
CaptainCyrilCommented:
I was just giving an example. So I changed 10 to 9 :-).

How about LEFT("1/1/2010",5) = "1/1/2".
0
 
tusharkanvindeCommented:
I like

STUFF(SUBSTR(DTOS(ldEndLastWeek),5),3,0,'/')
0
 
pcelbaCommented:
LEFT("1/1/2010",5) = "1/1/2"  is not this case because we have Date as the original parameter.

I suppose jayzm69 just needs to strip the year from the date which is already in required format (the year is at the end). The significant fact is the date format is OK for jayzm69 and he does not require any conversion:

AA/BB/YYYY

Thus LEFT(DTOC({^2010/9/1}), 5) will always return desired string because DTOC() adds leading zeros.

The STUFF() used by tusharkanvinde is cool.
0
 
CaptainCyrilCommented:
There is a setting in regional part of Control Panel that causes the date to return without leading zeroes. That's why I try to avoid any loose ends.
0
 
pcelbaCommented:
Yes, you are right but this works when SET DATE is LONG or SHORT only. Or am I missing something?

OTOH, I also don't like functions or conversions which could provide ambiguous results.
0
 
CaptainCyrilCommented:
That's why I proposed the DAY and MONTH functions. DTOS is stable across all as well.
0
 
pcelbaCommented:
So, let propose the post ID:34127460 as the solution and all others as assisted contributions...


BTW, I am just studying PARAMETERS (and LPARAMETERS) behavior. The interesting thing I've found is the possibility to RELEASE the variable used as a formal parameter (yes, this is not obvious deal with parameters).

This action unhides the variable originally used as the actual parameter (passed by ref) which is a little bit inconsistent with releasing the standard private variable where the originally hidden variable still remains hidden...

And yes, I know, this really don't look like a useful investigation. :-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now