Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

We use the following -SET command in a lot in our fexes to p...


Douglas Lee 2

Recommended Posts

Neither, just a fex that has the following code which will be used in various scenarios.

-SET &START_DT = &START_DT.(|FORMAT=YYMD).Select Start Date.QUOTEDSTRING;

Is there a way to change what the calendar actually outputs Like, in good ol days of the Calendar Control settings in the HTML Composer

Link to comment
Share on other sites

We use the following -SET command in a lot in our fexes to prompt the user for a date, and they seem to like the calendar prompt.

-SET &START_DT = &START_DT.(|FORMAT=YYMD).Select Start Date.QUOTEDSTRING;

However, the problem is the resulting date value is formatted like this: August 26 2020 which is nice for display, but not for screening within the WHERE statements or DM Commands like DATEADD, etc or other dialogue manager friendly for other functions like DATECVT, DATEMOV, etc.

Do you know of a way to change the format returned by the calendar, such as the YYMD format

Weve discovered defines work to convert it, but we need to convert it in DM and not a fex.

Thanks, Doug

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...