netseeker

Thanks for the response, my problem is not return only a single value but how to have multiple statements inside case? can you show me how to convert following java into FM : if (date <= 186) { switch (date % 31) { case 0: month = date / 31; date = 31; break; default: month = (date / 31) + 1; date = (date % 31); break; } year = miladiYear - 621; } else { date = date - 186; switch (date % 30) { case 0: month = (date / 30) + 6; date = 30; break; default: month = (date / 30) + 7; date = (date % 30); break; } I am java developer but I couldn't figure it out how to convert these above lines into FM functions. One more thing I saw FM has two types of programming, functions and scripts. Seems inside scripts we can have proper if/else and switch case is it so? or do I get it wrong?

Hi all, I want to write couple of complex statements like following : switch (day % 31) { case 0: month = (day / 31); day = 31; break; default: month = (day / 31) + 1; day = (day % 31); break; } //above code is in java but I coudn't find any way in FM to make me able to do such. All I know in FM is a very simple case something like : result = Case (test1;"result here";test2;"result 2 here";"default result); I want to do something like : Case ( 0 ; "month = (day / 31);day = 31;" ; "month = (day / 31) + 1;day = (day % 31)"; Actually I want to do some calculation before returing result and I want to do it inside case. Is there any way to do such in FM? Thanks in advance.

comment , thanks for your answer.

hi , what I mean by behavior is what I've mentioned in my previous post "sorting". I mean a correct sorting in date field in FM. assume I have a working "jalili calendar" algorithm in FM and I've implemented it already. does my "jalili" date fields sort correctly like the regular(christian) date fields? this is my big concern about customized date field in FM. and if there is a implemented source for "lunar calendar" (the arabic calendar) around would you please give me a clue about that? I think by looking at some other calendar types in FM I can find out how to fix this issue in FM. regards.

hi thanks for your response. actually I know how to calculate "solar hijri" in other words I have the algorithm. but the thing is I don't know how to implement it in FM I mean I want to create a date field but have "solar hijri" behavior not "Christian" behavior. is there any solution for creating such this kind of field in FM. or do you have any idea of how to convert different calendars to each other? and also does the converted calendar have the same behavior as original date (like sorting and stuffs)? regards.

I didn't know that we have several types of solar calendar. we need "jalali calendar" thanks in advance.

Hi, we are working in a company that interested to invest on filemaker but since we are located in middle east and we need solar calendar for our calculation. but I haven't found anything about solar calendar in FM. I just want to know is there any third party component for this purpose in FM or is it possible to write a specific date field for FM? regards.