Format Date Function Calls: Day of week number

0
Mendix Studio Version: 8.18.1 Hi all, I’m trying to get the number of a week day for a given date time value (e.g., ‘04’). Unfortunately I’m receiving the ‘Day of week abbreviation’ (e.g., ‘Thu’ ). The following examples returning an abbreviation and not a number.  formatDateTime([%CurrentDateTime%],'E') formatDateTime([%CurrentDateTime%],'EE')
asked
1 answers
3

Try this one:

EDay name in weekTextTuesday; Tue
uDay number of week (1 = Monday, ..., 7 = Sunday)Number1

 

See documentation here:

https://docs.mendix.com/refguide/parse-and-format-date-function-calls#1-introduction and

https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/text/SimpleDateFormat.html

Regards,

Ronald

 

 

answered