HOw to get date and time

[mfauzim]

How do I get datetime in MS so that I can insert the value into my MSSQL fieldtype datetime. I understand MS only has getdate and gettime not getdatetime

[Marcus Tettmar]

Use the Year, Month, Day, Hour, Min and Sec functions to extract each part of the date and time and format according to your requirements. E.g.:

Code: Select all

Year>yyyy
Month>mm
Day>dd
Hour>hh
Min>nn
Sec>ss
Let>FormattedDateTime=%yyyy%-%mm%-%dd% %hh%:%nn%:%ss%