何日前かを知りたい

日本 フォーラム
,
1

データに日付が記載された列があり、その各日付は本日から何日前かを知りたいです。

ご協力をお願いします。

2

@kunie

  1. First use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’.

  2. And then use ForEach Row activity to iterate one by one row.

    ForEach row in DT
    Int DateDiff = (Now - Cdate(row(“DateColumnName”))).TotalDays

3

Thank you so much.
It was a learning experience.

1 Like
4

@kunie

Glad to help you :grinning:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.