Issue with Calendar Funktion

[#1]

Hi all

I have a very stupid issue with my calendar and I don't know how to solve it...

I want to install some pre-settings when somebody choose this tab. Therefore I installed an Aktion, that QV will select the current month.

It worked until December, I found out that the formula month(today()) returns "Dez" for December. In the integrated calendar December is writting with a "c" ==> Dec.

How can I solve this? Any ideas? Thanks for your help.

Oliver

=Month(today())

[mato32188]

Hi Oliver,

check your variable settings in script ....set MonthNames = ...

BR

M

[morganaaron]

Hi Oliver,

It should be picking up the Month Name value from the SET statement in (by default) the Main tab in your load script - the statement will set the short month names that are used by that function, so 'Jan;Feb;Mar...' etc.

Check here that December is represented by Dec not Dez.

[MarcoWedel]

Hallo Oliver,

like already suggested you have to check your MonthNames variable in the script.

Like your screenshot suggests, instead of the german default definition for MonthNames:

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

your script might actually look like:

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dec';

Can you post a sample app to clarify?

Gruß

Marco

[#5]

hi all

this is very strange

I changed it in the datamodel and checked it everywhere (saving, reloading, etc.)

but it's still there...

Any ideas? Unfortunately I cannot post a sample...

[mato32188 · Accepted solution]

Hope, you havent missed variable settings at the very begining of your script...

set

set

set

set

if not, check your variables by Ctrl+Alt+V to be sure, you are not using any other formating for your month list box, else check your formating in list box directly.

[#7]

found it

Thank you very much for your help!

[sujeetsingh]

Check for this script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';