Extract month and day from date field

[Karchan]

Hello, I was wondering how to extract JUST the month and day of a date field (yyyy/mm/dd) in Crystal? Example for 2014/01/06 I just need 01/06. Eventually I need this field to do a datediff with another month/day field so just changing the formatting doesn't work. TIA.

 

[SkipVought]

hi,

You about the Year() and Month() functions?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Karchan]

Yeah but that just extracts part of the date, no? I figured a workaround by defaulting the year to 1999 for all the date fields. Example: date(1999,month(datefield),day(datefield)). This way I can retain it in a date format for when I do a datefiff function.

 

[Karchan]

Still having some trouble... the problem is between Dec 31 and Jan 1. How do you make Crystal count this as a datediff of 1 day instead of 364?
TIA.

 

[SkipVought]

You must use the ACTUAL dates!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[pmax9999]

All you need to do is use the original date field, and format it so that it does not display the year:

> Right click - Format Field
> Customize
> Year - None


Cheers
Pete.

 

[Charliy]

totext({table.field},"MM/dd")