Week Starting as Sunday and ending as Saturday
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) + 7) , "D-YMD[4,2,2]")
The above expression will provide the Previous Week Sunday
in YYYY-MM-DD format
Previous Week Saturday
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) + 7) + 6 , "D-YMD[4,2,2]")
The above expression will provide the Previous Week Saturday
in YYYY-MM-DD format
Use in the Transform function or as Activity Variable in the Sequencer .
'WEEK.TAG' with Sunday as start of week
Moderators: chulett, rschirm, roy
Get the Week Starting with Sunday
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) ) , "D-YMD[4,2,2]")
The above expression will provide the Week Starting with Sunday in YYYY-MM-DD format
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) ) + 6 , "D-YMD[4,2,2]")
The above expression will provide the Week Ending with Saturday in YYYY-MM-DD format
Thanks
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) ) , "D-YMD[4,2,2]")
The above expression will provide the Week Starting with Sunday in YYYY-MM-DD format
Oconv((Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD") ) - (Mod( Oconv(Iconv(Oconv(date(), "D-YMD[4,2,2]") , "DYMD"),"dw"),7) ) + 6 , "D-YMD[4,2,2]")
The above expression will provide the Week Ending with Saturday in YYYY-MM-DD format
Thanks