Extract holiday dates from Dollar Universe Calendar

[Angus Reid]

Windows 2019 DUAS v 7.01.02

Want to extract the dates of the holidays defined in the general calendar in a usable format like dd/mm/yyyy. Can this be done by a command?

There are lots of date commands such as ext cal mu=mymu since=2024  however that just show the entire calender with holidays marked with a 'h'.

Is there a way to just get the holiday dates for a year from DUAS?

-------------------------------------------

[Gilles deBuzonniere]

Hello,
I'm afraid there is no native command for that purpose...
But you could work on the output of uxshw cal command. For example on linux:
uxshw cal mu=* | sed 's@^[A-Z][a-z]*day  *:@DAY : @;s@ :   @:@;s@Year      : @Year:@;s@\([0-9][0-9]\) \([CHW]\)@\1:\2@g' | awk -F':' '/^Year:/{annee=$2} /^DAY:/{print annee ":"$0}'|sed 's@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@;s@  @:@;s@:    @:--:-@' | awk -F':' '{if($4=="H"){printf("%s/%s/%s\n",$1,"01",$3)};if($6=="H"){printf("%s/%s/%s\n",$1,"02",$5)};if($8=="H"){printf("%s/%s/%s\n",$1,"03",$7)};if($10=="H"){printf("%s/%s/%s\n",$1,"04",$9)};if($12=="H"){printf("%s/%s/%s\n",$1,"05",$11)};if($14=="H"){printf("%s/%s/%s\n",$1,"06",$13)};if($16=="H"){printf("%s/%s/%s\n",$1,"07",$15)};if($18=="H"){printf("%s/%s/%s\n",$1,"08",$17)};if($20=="H"){printf("%s/%s/%s\n",$1,"09",$19)};if($22=="H"){printf("%s/%s/%s\n",$1,"10",$21)};if($24=="H"){printf("%s/%s/%s\n",$1,"11",$23)};if($26=="H"){printf("%s/%s/%s\n",$1,"12",$25)}}' | sort

(This is just an example, and you can do better...)

-------------------------------------------

[Angus Reid]

Yes it would seem so, also no option to schedule on just holidays alone. 

One way would be to create a rule but disallow workdays and allow closed days that are not on the weekend. Still tricky to extract the dates using a command but could play about with a FLA command and and get a task to show launch dates.

Pity as the calendar and the uxdat and utim command are some of the most useful ones in DUAS. Would be good if there was a command to extrract dates over a time period as a table or something although the task simulation is great though its just visual.

-------------------------------------------