How to extract value in Crystal Report

C# Corner

Ramco Ramco

1y1.1kCrystal Reports

I have date value like this 07/08/2024.I want to get values before second "/" i.e 0708 in Crystal report formula.

. If date is 7/08/24 then 0708

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naveen Kumar1y ago

Check the below formula. Replace {YourDateField} with the actual name of your date field in the report.

Local StringVar DateString := ToText({YourDateField}, "dd/MM/yy");
Local StringVarArray DateParts := Split(DateString, "/");

Local StringVar DayPart := Right("0" + DateParts[1], 2); // Ensures 2 digits for day
Local StringVar MonthPart := Right("0" + DateParts[2], 2); // Ensures 2 digits for month

DayPart + MonthPart

Muhammad Imran Ansari1y ago
// Assuming your date field is named {YourDateField}, convert it to a string if needed
```
Local StringVar dateString := ToText({YourDateField}, "MM/dd/yyyy");
```
// Replace "/" with an empty string and then take the first 4 characters
```
Left(Replace(dateString, "/", ""), 4)
```

Jignesh Kumar1y ago

use this formula on your date field,

Replace(Split({YourDateField}, "/")[1] + Split({YourDateField}, "/")[2], "/", "")