How to assign dates using eval

[raghu0463]

Hi,
Here I want to assign Initial_L1_Decision_Date dates to Queue_to_Initial_L1_Days. There are some dates for Initial_L1_Decision_Date, but the table for Queue_to_Initial_L1_Days does not show any dates, I'm getting all blanks.

index = index_T1 source= Source_E1 sourcetype = SourceType_E1 |eval Queue_to_Initial_L1_Days = strftime(Initial_L1_Decision_Date, "%Y-%M-%D %H:%M:%S") |table Queue_to_Initial_L1_Days

Thanks

[DalJeanis]

Be sure to mark code as code.

[richgalloway]

Is Initial_L1_Decision_Date in epoch form? There's a typo in the strftime format string. Try "%Y-%m-%d %H:%M:%S".

[DalJeanis]

@raghu0463 - I moved this comment to answer because it's the answer.

Use "%Y-%m-%d %H:%M:%S"
Month is %m, not %M
Day is %d, not %D

[ddrillic]

Sample data maybe ; - )