IF THEN ELSE in expression builder

[Luc Verlee]

I'm completely new to A5.
Based on a field "DATE" I want to have the name of the day of that particular date to appear in a calculated field called "name_of_the_day". In field rules of "name_of_the_day" I use the expression builder to CDOW(DATE) which produces correctly the name. Okay so far.
But then I want to translate the name of the day into another language e.g "Monday" to "Lundi" . So I thought to put after the CDOW(DATE)expression an IF THEN expression something like IF DATE="Monday" THEN DATE="Lundi"
but I seem to miss the correct expression. Searched the manuals but cannot find anything.
Can somebody point out the correct expression and where to look in the manuals ? Thx

[Vince McGinnis]

Luc

I would look a two functions in particular.

These can be found in the functions and expressions (PDF)book.

Look at:

cdow()

this returns the day of the week

also look at:

CASE() function

to wook out the logic

[Al Buchholz]

Luc

Found this with a search.

http://msgboard.alphasoftware.com/alphaphorum/read.php3?sortby=lastreply&direction=desc&num=11&id=49248&thread=49246

Took a chance at making a function of it.

Take the attached file, save it, and use the code import. Control panel - code tab - code (on menu) - import. Follow the dialogs to import the one function. It will create a function that you provide the numeric day of the week and you'll get the day of the week in french.

You'll now have a function that you can use like:

jours(1) or jours(dow(date()))

[Luc Verlee]

Thx Vince !

[Luc Verlee]

Thanks Al ,

Just great ! Didn't know it could be done that way. So once this function exists it can be used in whatever database.
Think I have a long way ahead studying !

[Al Buchholz]

Luc

You stated:
So once this function exists it can be used in whatever database.

My reply:
Just to be clear, you can use this in the database that it is imported to.

You can import this into any other database or you can learn about the .aex files to make it available on any database for one Alpha 5 installation.