Data table that has date field

Help
, , ,
1

Hello All,

I am trying to write a code, that checks an excel, if the column ‘zbc’ has date, current date +1, then perform some action.

Any leads pls?

2

Hi @PavithraSundaram

(Current date +1) meaning plus one month, day, hour … ?

4

currentdate + 1 day

5

Hi @PavithraSundaram
Use Cdate(row(“zbc”).ToString(“dd/mm/yyyy”)>Date.Now.ToString.AddDays(1).ToString(“dd/mm/yyyy”)

Thanks
Ashwin S

6

Okay,

So is you want only to check if the value is a date you can use the function isDate(row("zbc")) this gonna return True or False.

To achieve the comparaison between the column zbc and tomorrow the expression should be:

Cdate(row("zbc")).ToShortDateString >= Now.AddDays(1).ToShortDateString

Regards,
Reda

7

in dd/mm/yyyy: mm refers to minutes rather than the month.

8

thanks Reda! I definitely know that the column i need contains only date in the format MMM dd, yyyy. How do I check if that is = or 1 day less than the current date???

9

Okay so what I understand from your question is that you want your zbc date to be whether yesterday or today.

in this case use this in an assign

   Cdate(row("zbc")).ToShortDateString = Now.ToShortDateString OR Cdate(row("zbc")).ToShortDateString = Now.AddDays(-1).ToShortDateString

Regards,
Reda

2 Likes
10

Thank you Reda!