BusinessObjects Board

Convert text data to Date format

building reports webintelligence
#1

Hi expert,

I have date in text data 20220216 now I want to convert to date format to get different with current date.

Pls help us to convert in date format.

Thanx a lot for your kind support

BR
Sultan

#2

To convert it to a date, use =ToDate([Your object],"yyyyMMdd")

You can then compare this new object to your existing date objects (or relative dates like CurrentDate()).

Note that formatting dates is something different - FormatDate converts dates back to text, rather than displaying a date in a given format. To display a date how you want to in a report, add it and then format it by choosing to format its containing cell rather than using the FormatDate function.

That said, if you wanted to make a date part of a sentence, then you could have something like:
="Last transaction was on "+FormatDate([Your Date Object];"dd//MM/yyyy")

4 Likes
#3

Thank you Mark for your support. This is working fine.