Need to mix Char and Datetime

[Wallie12]

I need a field to have possible mix results such as when

IF SID = A then "NA"
ELSE
IF SID = B then DATETIME
ELSE
IF SID = C then "-'

Thanks for the help!

 

[Turkbear]

Hi,
What type of field is SID in the database?

You could convert the DATETIME to a string using something like

IF SID = A then 
"NA"
ELSE 
IF SID = B 
then 
ToText(DATETIME,'formatstring')
ELSE 
IF SID = C 
then "-'

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Wallie12]

When I do use the following
IF SID = A then
"NA"
ELSE
IF SID = B
then
ToText(DATETIME,'formatstring')
ELSE
IF SID = C
then "-'

??? How do I select 24 hour formatting for Hours and Time?

 

[Turkbear]

Hi,
If you use HH and not hh for the hours it should show in 24hr format.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Wallie12]

Can you provide me with an example Please

ToText(DATETIME,'formatstring')

I am clueless!

Thanks

 

[chelseatech]

The format you are looking for 24 hour time is "HH:mm".

The format string is case sensitive. "hh:mm" is 12 hour clock, and "dd-MM-yyyy" gives you day-month-year while "dd-mm-yy" gives you day-minute-year

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Turkbear]

Hi,

So you can use:

ToText({DateTimeField},'MM/dd/yyyy HH:mm:ss')

Here is a site with full info about format strings ( it is also in the CR help):

http://publib.boulder.ibm.com/infoc...ation.eclipse.designer.doc/html/topic629.html

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Wallie12]

Thanks