Any Date format to server Date format - urgent pls

HCL Domino Domino Forum
1

HI All,

I’m using (Text field Computed )explode function and getting some date range after that i’m using @texttotime to convert that in to date format it is giving me in the format of mm/dd/yyyy which is picking from System date format but what i want is dd/mm/yyyy in this format or how can i change the date format (whatever the regional settings may be) according to the server date format (which formula function i can use).

thx in adv.

regds,

Sathish.S

2

Subject: Any Date format to server Date format - urgent pls

Try this in the column formula (where DateFromForm is supposed to be the Date/time field on your form:

DBdate :=DateFromForm;

REM {base call date};

dttTemp := @Date(DBdate );

strWEDay := @If(@Length(@Text(@Day(dttTemp)))=1;“0”+@Text(@Day(dttTemp));@Text(@Day(dttTemp)));

strWEMonth := @If(@Length(@Text(@Month(dttTemp)))=1;“0”+@Text(@Month(dttTemp));@Text(@Month(dttTemp)));

strWEYear := @Text(@Year(dttTemp));

REM{Date formated according to European Date format};

strFinal:=strWEDay+“/”+strWEMonth+“/”+strWEYear;

strFinal

3

Subject: Any Date format to server Date format - urgent pls

@Explode on a date range does return a string, but there’s no reason to store it anywhere as a string. Stick to date-time values and you’ll never have to worry about formatting – each machine will see the value in its own format without any code.