Date Field Keywords

 

Keywords available through MoversSuite date fields are described in the table below.  To use them, simply begin typing in the keyword into any date field and the application will automatically fill-in the value and set the date accordingly.  The application will validate the entry once the user navigates away from the field (pressing TAB, clicking on a different field, etc.).  The resulting format will always be in MM/DD/CCYY format and the date is based on application server settings.

 

Each keyword can also be used with a plus (+) or minus (-) followed by a certain number of days.  For example, if the date needs to be 30 from the end of the current month the user can enter “eom+30.”  To set the date to 10 days from the current enter “today+10.”

 

Keyword

Description

today

Current system date

yesterday

Date prior to current system date

tomorrow

Date following current system date

Note:

For the day of the week values, the application will check to see if the current date

Sunday

Will be the current date (if Sunday) or the upcoming Sunday

Monday

Will be the current date (if Monday) or the upcoming Monday

Tuesday

Will be the current date (if Tuesday) or the upcoming Tuesday

Wednesday

Will be the current date (if Wednesday) or the upcoming Wednesday

Thursday

Will be the current date (if Thursday) or the upcoming Thursday

Friday

Will be the current date (if Friday) or the upcoming Friday

Saturday

Will be the current date (if Saturday) or the upcoming Saturday

first

First day of the week (Sunday)

second

Second day of the week (Monday)

third

Third day of the week (Tuesday)

fourth

Fourth day of the week (Wednesday)

fifth

Fifth day of the week (Thursday)

sixth

Sixth day of the week (Friday)

seventh

Seventh day of the week (Saturday)

bom

Sets the date to the first day of the month

eom

Sets the date to the last day of the month

now

Sets a date and time field to the current date and time (only works on fields that contain both a date and time value)

 

Date fields will also recognize the month and set the initial portion of the date accordingly.           

 

Keyword

Description

January

Sets the month portion of the date to January

February

Sets the month portion of the date to February

March

Sets the month portion of the date to March

April

Sets the month portion of the date to April

May

Sets the month portion of the date to May

June

Sets the month portion of the date to June

July

Sets the month portion of the date to July

August

Sets the month portion of the date to August

September

Sets the month portion of the date to September

October

Sets the month portion of the date to October

November

Sets the month portion of the date to November

December

Sets the month portion of the date to January