Date Manipulations

[mh_elhassan]

Hello there,
i need your help in the following
i need a node to generate system date (Probably the date & time input node) then substract 1 day from it then filter all the days that are below or equal (system date -1 day)

can any one please help

[elsamuel]

There is no single node that will do this. The steps I’d take are

• use the Date&Time Input node (with the Use execution time option selected)
• Convert this variable to Date&Time
• Use Date&Time Shift node to subtract 1 day
• Convert the shifted date to a flow variable
• Apply this flow variable as end date in Date&Time-based Row Filter node.

Date&Time filtering example – elsamuel

[omprakashjena]

@mh_elhassan - You can use the Create Date&Time Range node to generate the system execution date and time followed by a Date&Time shift node to 1 day from it.

Then you can do the filtering using rule-based row filter or date&time based row filter.

Thanks

[mh_elhassan]

I have just found how we can use the variable to table row. thanks a lot. I believe this will work. thanks a lot wonderful community

[mh_elhassan]

thanks dear. it is much appreciated

[mh_elhassan]

Hey @elsamuel, i tried it but i got stuck in in the string to date node. I tried this format dd.MM.yy HH:mm:ss, but it didnt work. i tried also M/d/yyyy with choosing date only and it did not work either. any hints please?

[mh_elhassan]

@elsamuel i choose date only in the date & Time input node, and i was able to transform the date. However, for future needs, if i need to convert date & time from string to date, what is the right format because i tried many and none worked